If MSDB is corrupted and SQL Server not started what you do?

Question

Post reply

If MSDB is corrupted and SQL Server not started what you do?

Reo

Hall of Fame

Points: 3774
More actions
January 15, 2010 at 7:41 am

#218285

Hi All;
If MSDB is corrupted and SQL Server not started what you do?
Ram
MSSQL DBA

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Consult the documentation, then restore from backup.

http://msdn.microsoft.com/en-us/library/ms190749.aspx

Interview question?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Reo Hall of Fame Points: 3774 More actions · Answer 2

Hi;

thanks to reply!

the concern is that If my Instance in not running and it is not able to start then how I will restore?

Ram
MSSQL DBA

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Consult the documentation.

http://msdn.microsoft.com/en-us/library/ms190190.aspx

http://msdn.microsoft.com/en-us/library/dd207003.aspx

Interview question?

btw, msdb corruption shouldn't prevent the SQL database engine from starting. It'll prevent SQL Agent from starting.

I just tested this out on SQL 2005, renamed the msdb data file so that the MSDB database would come up suspect, then started the service. SQL started fine, MSDB is suspect and I could easily restore from a backup (assuming I had one)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Reo Hall of Fame Points: 3774 More actions · Answer 4

Gr8 sir:-D

That’s my question why the trying to confuse in interview? He told me that SQL server is not starting due to MSDB database corruption. And forcefully telling me that SQL Server not starting due to MSDB corruption.

His question that How u will restore MSDB database?

I know very well how to restore system databases and user databases. but he never will know; what I know.

Ram
MSSQL DBA

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

baghel_ramdas (1/15/2010)
That’s my question why the trying to confuse in interview? He told me that SQL server is not starting due to MSDB database corruption. And forcefully telling me that SQL Server not starting due to MSDB corruption.

He's probably testing to see if you know what you're talking about. Besides, there are ways to restore system databases if the damage to those DBs is preventing SQL from starting. If you're an experienced DBA, you should know them, or at least you should know it can be done. Otherwise you should at least have an explanation on how you will find out how to fix the problem (hint Books Online)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass