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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring Master from a backup of another server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-20 : 08:26:20
Eric writes "Hello,

I'm trying to restore master from another server's backup. I'm able to do it through the GUI, but when I try to restart services it fails because it's looking for the master.mdf file in the location where it sits on the original Server.

It looks like the "Move to physical file name" option isn't working.

Thanks for your time,
Eric"

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2006-02-20 : 11:56:35
Read this:

http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.asp

and this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

The System Databases are a little trickier to move that regular User Databases....
Go to Top of Page
   

- Advertisement -