Database Creation Help
От | Dean Jones |
---|---|
Тема | Database Creation Help |
Дата | |
Msg-id | 80g5a5$uvs$1@news1.konnect.net обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: