Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to chang...

@Marc: Thanks for asking. The way I implemented this was that a backup device was created once. Backups were then scheduled to this device via a scheduled job/task. Instead of passing the same UNC path again and again to the scheduled job, I thought ...

Have you ever wondered when your index was last rebuilt/reorganized? Here are two versions - using the Catalog view sys.indexes that would help you to identify the last date/time when the index statistics were updated, the number & percentage of rows ch...

SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destin...

SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destin...

SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destin...

SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destin...

Additional rows are added to the backup and restore history tables after each backup or restore operation is performed. Hence, it is recommended that these history tables are periodically cleaned up. These SQL Server system stored procedures help you to...

Additional rows are added to the backup and restore history tables after each backup or restore operation is performed. Hence, it is recommended that these history tables are periodically cleaned up. These SQL Server system stored procedures help you to...

How do you identify system and user databases programatically? How do you hide the "master" database from the user when running an installer? Use these scripts to either list system or user databases as requried....