Data Engineering – Learn from the experts
-
Estimated Time for Backup / Restore
This script can be used to find the estimated time of backup and restore that is on progress in your SQL server. This script is applicable for SQL server 2005 and above.
-
Check if /3GB is configured or not
This script is used to check whether the 3gb switch is configured or not in the boot.ini file. This script is applicable for SQL server 2005 and above.
-
List Orphan ID’s
This script displays the list of orphan SQL Server accounts from all the databases. This script is applicable for version greater than SQL 2000.
-
How to Recover SA password when you forget it – SQL 2005
What to do if you forgot SA password in SQL Server 2005? In general if you forgot SA password or if the SA account is disabled these are the options to login into SQL Server 2005 and reset or enable SA.
-
List of DMVs & DMFs available in SQL Server 2005
I’ve listed down all the DMV’s that are related to SQL server 2005
Got any recommendations?