Discussion: Restoreing MASTER DB
Afficher un message
Vieux 27/03/2008, 21h45   #2
Tibor Karaszi
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Restoreing MASTER DB

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


  Réponse avec citation
 
Page generated in 0,05664 seconds with 9 queries