error: The request failed or the service did not respond in a timely fashion
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.
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.
- 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]
other Good Reference: