master database crash

Question

question

athma asked Jan 22, '11

please give me the steps to overcome master database crash or any system database crash.

administration

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Jan 24, 2011 at 04:55 AM

Please tell me this isn't asked as a result of your previous question on moving sys databases!

1 ·

Answer 1 · 2011-01-22T22:41:02Z

Adiga answered Jan 22, '11

1. You can [RESTORE][1] master database from Backup. 2. [REBUILD][2] the master database [1]: http://msdn.microsoft.com/en-us/library/ms190679.aspx [2]: http://msdn.microsoft.com/en-us/library/ms143269(v=sql.90).aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2011-01-23T00:26:05Z

Håkan Winther answered Jan 23, '11

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Jan 24, 2011 at 05:07 AM

nice link Håkan. +1

0 ·