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 - 2001-07-27 : 10:10:00
|
| Mitch writes "I am running SQL Server 7.0, with no service packs applied, on a Windows 2000 server and am testing backup and restore scenarios.The current scenario is that I have completely lost my production server and need to restore to an alternate server from backup. My alternate server does not have the same disk layout as the production server and I am installing SQL Server on this box from CD-ROM.I have successfully recovered the master db on this second server. But when I want to restart it after the restore it expects the model db and the temp db to be in the locations they had on the old production server. If this location does not exist I cannot start the SQLserver service. When I provide this location, then everything starts up.So, how do I restore the master to an alternate location without being forced to provide the old location for the model and temp databases?" |
|
|
|
|
|
Changing location of model db during restore of master db to alternate server.