SQL scripts that may be helpful for MS SQL Server DBAs in their daily tasks:
SQL scripts that may be helpful for MS SQL Server DBAs in their daily tasks: 1.Script to Backup a Database: BACKUP DATABASE [YourDatabaseName] TO DISK = 'C:\Backup\YourDatabaseName.bak' WITH INIT, FORMAT, COMPRESSION; 2.Script to Restore a Database: RESTORE DATABASE [YourDatabaseName] FROM DISK = 'C:\Backup\YourDatabaseName.bak' WITH REPLACE, RECOVERY; 3.Script to Check Database Integrity: DBCC CHECKDB ('YourDatabaseName') WITH NO_INFOMSGS; Script to Shrink Transaction Log File: DBCC SHRINKFILE ('YourDatabaseName_log', 1); SELECT r.session_id, r.start_time, r.status, r.command, t.text AS [SQL Text] FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t WHERE r.status NOT IN ('background', 'sleeping') ORDER BY r.start_time DESC; 4..Script t...