| From: | "Dean Jones" <jonesdl(at)konnect(dot)net> |
|---|---|
| To: | pgsql-questions(at)postgresql(dot)org |
| Subject: | Database Creation Help |
| Date: | 1999-11-12 04:27:29 |
| Message-ID: | 80g5a5$uvs$1@news1.konnect.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello All;
I need some direction on how best to create/setup my data on a small client
application. MS SQL 6.5 creates a MSDBData and a MSDBLog device when it is
first installed. I am going to create a small application that will access
data in a database called MYTESTTBLS. Should I use the MSDBData and MSDBLog
as the devices for the data/log or should I create a new device, one for the
data and another for the Log file and associate my database to these? I
plan on putting about a dozen tables in the MYTESTTBLS database, each of
which will have lots of data that will grow on a daily basis. I'm new in
this area and want to set up MS SQL correctly so I need some guidance.
Also, if new devices (data/log) are required, how do you script this? I
looked in all the on-line help that comes with MS SQL 6.5 and I can't seem
to find any place that says how to script a new data/log device. I found
Create Database, but no Create Device syntax. Any help in this matter would
be much appreciated.
Dean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | V Krishnaraj | 1999-11-12 05:23:29 | Postgres concurrency : urgent |
| Previous Message | Vadim Mikheev | 1999-11-12 01:25:15 | Re: [GENERAL] Postgres concurrency : urgent |