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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-19 : 08:15:40
|
| Jeff writes "I would like to know if there is a good way to move the Master DB and system DB's to another location on the same server. I have hacked around with it. Sometimes it works and sometimes it doesn't. The way I have played with it is:Update sysfiles1 with the new location,Update the Registry with the new location.Is this correct or is there a better way.Thanks.Jeff" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-19 : 08:18:55
|
| ABSOLUTELY NOTNEVER update system tables. It is the most certain way to FUBAR your SQL Server. Do not think that because nothing went wrong this time that it couldn't go wrong.The best way to move the master database is to follow the directions in Books Online for "restoring master" (use the search feature to find the exact entry) Look under the T-SQL directions, and add the WITH MOVE clause to change the path of the data and log files. BOL also has all the syntax for the RESTORE command, including WITH MOVE. |
 |
|
|
|
|
|
Move Master