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: | Raw Message | Whole Thread | 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 |