error: The request failed or the service did not respond in a timely fashion

timely fashion error

Reasons:

1.Recently, An unexpected shutdown of my Database server has resulted in crashing of the     SQL Server Instance and I was unable to restart SQL Server.

2. SQL Server master database becomes corrupt, such as from its disks losing power                   while SQL Server was running.

Analysis:

I was unable to connect to SQL Server Instance and when I checked the SQL Server error logs, I could see the following entries

“Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. “

Now what do I do? I don’t have backups of SQL Server System databases!

Since I don’t have the system databases backups, the only option left for me was to rebuild the system databases.

Troubleshoting:

  1. Rebuild master database when master database file corrupted but backup is not available

 

==>

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName
/SQLSYSADMINACCOUNTS=accounts [/SAPWD= StrongPassword][/SQLCOLLATION=CollationName]

Ref: http://www.mytechmantra.com/LearnSQLServer/Rebuild_System_Databases_In_SQL_Server_2008.html

How to Rebuild Master Database?? AKA Rebuilding SQL Server 2008R2.

other Good Reference:

http://blog.sqlauthority.com/2014/11/25/sql-server-fix-the-database-model-is-marked-restoring-and-is-in-a-state-that-does-not-allow-recovery-to-be-run/

 

Advertisements