Restore master DB to another server? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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 2005 Forums

SQL Server Administration (2005)

Restore master DB to another server?

Author

Topic

Mickoni
Starting Member

8 Posts

Posted - 2007-06-12 : 07:51:00

I have a full backup from ServerA. I then put ServerB in single user mode and try to restore the backup from ServerA. (both are identical servers but have different names)

[*- From command prompt using sqlcmd -*]

USE master
GO
RESTORE DATABASE master
FROM DISK = 'D:\BACKUPS\serverA.bak'
GO

Msg 3154, Level 16, State 4, Server MSSQL1, Line 1
The backup set holds a backup of a database other than the existing 'master' database.

Msg 3013, Level 16, State 1, Server MSSQL1, Line 1
RESTORE DATABASE is terminating abnormally.

Any ideas on forcing the restore through T-SQL? The restore works fine from a master backup from itself (ServerB).

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-12 : 11:55:58

Try add 'with replace' in your statement.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources