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 - 2002-07-08 : 08:43:38
|
| Allon writes "As part of a new Disaster Recovery Plan for work, I was told to try to restore the master database file from backup to a different sql 2000 server (hardware same as original, only difference is one is partitioned as 3 drives, the other as only 1 drive). Don't ask why, but I was told not to set up new server with 3 partions (like original). The master.mdf usually resides on the e:\path of Server A. I am trying to restore it to the c:\path of Server B. So far I have only gotten this far:1. Copied master_DB_62502.BAK from Backup to root of C:\.2. Start SQLSERVR in Single User Mode3. In Query Analyzer run: restore database master from disk='c:\master_DB_62502.BAK' with move 'master' to 'c:\program files\microsoft sql server\mssql\data\master.mdf', move 'mastlog' to 'c:\program files\microsoft sql server mssql\data\mastlog.ldf', replace goThe restore process is successful (as stated in Query Analyzer), and SQL shuts down, but when I try to restart the services it does not load, and gives me an error. When I tried running SQLSERVR from command prompt I saw that it was trying to open (unsuccessfully) from e:\path.. and after failing, attempted to load the model database. Why is this happening? What can I do?Only the SQL TEAM can help me now.Thanks,AllonSPECSDELL 2550 Server with Windows 2000 Server SP2SQL 2000 SP1" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-07-08 : 09:53:38
|
| Well the model, msdb, and tempdb databases were located on a different drive of the original server as well right? So naturally your SQL Server can't find them when you restored master from backup! I believe you should be able to start the server with the trace flag 3608 (bypass recovery of system databases except master) and then restore (or attach) your msdb and model, alter tempdb to be on the correct drive and restart the server without the trace flag. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-08 : 10:55:45
|
| [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]Good coverage of moving system databases.HTHJasper Smith |
|
|
|
|
|
|
|
|
restore master database to different drive