April 7, 2004 at 9:06 am
am going to install sql server 2000 in a new server. The data files are going to be in the F drive and transaction logs are going to be in D drive. I see in the set up of the cd where you can change the location of the datafiles. But I don't see anywhere a place to change the transaction log files. After the set up is done the master (system databases) datafiles hould be in F drive and master logfiles should be in D drive. Could you please tell me where I can change the transaction log file location?
April 7, 2004 at 10:17 am
In Enterprise manager you can set the default location of both the data files and the transaction log files (for new databases).
Right Click on the server
Choose properties
Choose the database settings tab
At the bottom there is a section called 'New database default location' with a place to set both these values.
You can move the existing files eg master, msdb. For this it is best to search the siteas there are a few articles/threads on how to do it correctly.
Hope this helps
Steven
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply