Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-11-29 : 15:29:57
|
| Hello,I need to change the MDF and LDF locations to another drive/disk for all system databases.How do I do it since it won't let me get the db into single user mode and RESTORE command needs the db to be in single user?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-12-01 : 05:13:59
|
| For Master database:Change the path for master (data and log) in EM.You need to change this values on STARTUP PARAMETERS (right click SQL Server and click properties).Make your change.Stop SQL Server.Copy master (data and log) to the new location.Start SQL Server.For others db have a look at:http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071Good luck.Franco |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-12-01 : 17:06:15
|
| Thank You. I was able to find that document on sunday. I didn't pay attention to the order of model and msdb dbs move first but I fixed it later. Model got to go first. The move was successful.-Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
|
|
|
Changing Master Data and Log Files