Restoreing MASTER DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat.Rick - 27 Mar 2008 21:26 GMT

Hi Freinds,
SQL2005

I rebuild my server and trying to restore master DB, I start server in
single mode, but I'm getting this error:
SP2 and all patches are the same.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\>sqlcmd
1> restore database master from disk = 'D:\SQL_BACKUPS\master.bak';
2> go
Msg 3154, Level 16, State 4, Server LADBREPORT, Line 1
The backup set holds a backup of a database other than the existing
'master' dat
abase.
Msg 3013, Level 16, State 1, Server LADBREPORT, Line 1
RESTORE DATABASE is terminating abnormally.
1>

what could be the reason ?

Thanks in advance,
Pat

Reply to this Message

Tibor Karaszi - 27 Mar 2008 21:45 GMT

Start by investigating what is on that backup file using RESTORE HEADERONLY.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi Freinds,
> SQL2005
[quoted text clipped - 21 lines]
> Thanks in advance,
> Pat

Reply to this Message

TheSQLGuru - 27 Mar 2008 21:48 GMT

Are you following the very detailed instructions in BOL for how to restore a
master database?

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Hi Freinds,
> SQL2005
[quoted text clipped - 21 lines]
> Thanks in advance,
> Pat

Reply to this Message