Creating a Database and Verifying Its Data and Log Files
I have recently encountered an issue where one of the databases suddenly moved to Recovery Pending status after SQL Server fail-over.
I checked the database and it is in status. Then
This will work for Agent jobs that have T-SQL job steps pointing to a database.
Running the script below will show you the last access date and time of all databases since the day sql server was rebooted
It is not a good practice to keep Autoshrink on because it will cause indexes to become fragmented. If you want to reclaim free space then a better approach is to manually shrink the files and then rebuild the indexes.
By default AutoShrink feature is turned off in SQL Server
Use this script to create alerts for disk I/O errors.
Before running the script replace the <OperatorName> parameter with the actual operator that you would like to alert.