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

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

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


"Pat.Rick" <PatrickAlexander.email@gmail.com> wrote in message
news:2b5d318f-03a4-4fb0-b300-18a1cf177c0c@d4g2000prg.googlegroups.com...
> 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

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


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


"Pat.Rick" <PatrickAlexander.email@gmail.com> wrote in message
news:2b5d318f-03a4-4fb0-b300-18a1cf177c0c@d4g2000prg.googlegroups.com...
> 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