sql installation help -- sql server new users

Shoby
1/18/2006 1:16:07 PM

we are installing sql server 2000 Enterprise edition on windows 2003 server.
The thing we want to do is when we install sql we want the sql transaction
log files to be in seperate drive because sometime they tend to be really
big. can somebody please tell me how to do it

thank you
shoby

Danijel Novak
1/19/2006 9:59:54 AM

Hi,

When creating database you can specify where physical files for the database
will reside.
There you can use different drives for data nad log.

--
Danijel Novak

[quoted text, click to view]

sql server new users : sql installation help