Anybody have step by step instructions on how to restore systems db's in SQL 2005

Question

Anybody have step by step instructions on how to restore systems db's in SQL 2005

vikashbhasin

SSC Rookie

Points: 35
More actions
December 21, 2009 at 3:11 pm

#385988

Anybody have step by step instructions on how to restore systems db's in SQL 2005? Any help would be appreaciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

vikashbhasin SSC Rookie Points: 35 More actions · Answer 2

ohh i thought we had to use Sqlservr.exe –c –m for single sign on and then recover the master db?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

http://msdn.microsoft.com/en-us/library/ms190679(SQL.90).aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

To restore the other system dbs, no. You only need to restart in single user mode for the master db.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events