Database Creation Help

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

Browse pgsql-general by date

  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