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