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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-02-22 : 14:01:19
|
| By, system database are installed in C: drive and it is Production Server now. Is there a way to move system database to D: drive without affecting Server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-22 : 14:22:44
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2kTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-22 : 14:27:30
|
| Tara,How much risk is involved while moving system database? I see this very risky. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-22 : 16:15:16
|
| I've done it several times and haven't had any issues. There is risk involved, but you can mitigate it by taking full backups of everything once you start. Don't let anyone on your system until you are done and everything has been tested that way if there is a problem you can simply restore from your backups and know you are back to how it was.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-22 : 16:42:11
|
| Moving a master Database looks really Scary. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 14:49:58
|
| Not really if you follow steps properly, just keep good backup of system dbs. |
|
|
|
|
|
|
System database