Database Issues - Troubleshooting


1. Offline
i. ALTER DATABASE <DBNAME> SET ONLINE
ii. EXEC SP_RESET STATUS
iii. Before doing this make sure that we inform the DB Users that we are going to work on it to make necessary troubleshooting steps.
iv. Reason can be found in SQL Server Logs why/how/who has taken the database offline.
User Unable to connect
Slow response from the DB when user connected
Suspect
DB Corrupt
DB is in Restoring state

No comments:

Post a Comment