Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restore system databse Expand / Collapse
Author
Message
Posted Thursday, August 18, 2011 4:03 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 1:13 PM
Points: 774, Visits: 1,734
Hi All,



I tried to restore the system databases. I was able to restore the master but model and msdb were giving errors. what is also observed once after master is restored, sql server stopped and i had start it once again using -T3608 trace flag


backup database master to disk = 'd:\sqldump\master.bak'
backup database model to disk = 'd:\sqldump\model.bak'
backup database msdb to disk = 'd:\sqldump\msdb.bak'

restore headeronly from disk = 'd:\sqldump\master.bak'
restore headeronly from disk = 'd:\sqldump\model.bak'
restore headeronly from disk = 'd:\sqldump\msdb.bak'

-- verified the backups

restore verifyonly from disk = 'd:\sqldump\master.bak'
restore verifyonly from disk = 'd:\sqldump\model.bak'
restore verifyonly from disk = 'd:\sqldump\msdb.bak'

/*

The backup set on file 1 is valid.
The backup set on file 1 is valid.
The backup set on file 1 is valid.

*/



C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn>sqlservr.exe -sSQLEXpre
ss03 -T3607

C:\>sqlcmd -Swin\SQLEXPRESS03 -E
1> restore database master from disk = 'd:\sqldump\master.bak';
2> go
Msg 3108, Level 16, State 1, Server WIN-SEVEN\SQLEXPRESS03, Line 1
To restore the master database, the server must be running in single-user mode.
For information on starting in single-user mode, see "How to: Start an Instance
of SQL Server (sqlservr.exe)" in Books Online.
Msg 3013, Level 16, State 1, Server WIN-SEVEN\SQLEXPRESS03, Line 1
RESTORE DATABASE is terminating abnormally.
1>


C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn>sqlservr.exe -sSQLEXpre
ss03 -T3607 -m


C:\>sqlcmd -Swin\SQLEXPRESS03 -E
1> restore database master from disk = 'd:\sqldump\master.bak';
2> go
Processed 360 pages for database 'master', file 'master' on file 1.
Processed 2 pages for database 'master', file 'mastlog' on file 1.
The master database has been successfully restored. Shutting down SQL Server.
SQL Server is terminating this process.

C:\> -- sql server stopped

C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn>sqlservr.exe -sSQLEXpre
ss03 -T3608

1> restore database msdb from disk = 'd:\sqldump\msdb.bak';
2> go
Processed 712 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 6 pages for database 'msdb', file 'MSDBLog' on file 1.
Msg 3283, Level 16, State 1, Server WIN-SEVEN\SQLEXPRESS03, Line 1
The file "MSDBLog" failed to initialize correctly. Examine the error logs for mo
re details.
Msg 3013, Level 16, State 1, Server WIN\SQLEXPRESS03, Line 1
RESTORE DATABASE is terminating abnormally.
1>



Can anyone figure what the problem is all abt??

I also tried with MOVE option, still the same error for model and msdb.

I see they are in restoring state in management studio.

Thanks any advance.

Post #1162158
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse