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