Full backup Scenario

Backup or Restore progess

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.

Corruption Recovery Tips, Database Shrinkage Advice and More

Question: My backup strategy is a daily full backup at 1 a.m. and a log backup every hour. A DBCC CHECKDB also runs every day at 4 a.m. If I get to work at 8 a.m. and discover that the nighttime consistency checks found extensive corruption, how can I recover without losing a lot of data?

Striping SQL Server Database Backups

As databases get larger, the time for database backups to complete grows as well. Unfortunately, the time window for your backups may not increase. It could very well be the case that you reach a point where your backups will not finish in a specified amount of time.

Transaction Log Backups

Automated SQL Job to Backup Database(s)

Automate All Database Backups with this script. handle full, diff, and log backups.

Enterprise wide Backup Audit

Enterprise wide Backup Audit that produces backup information in a csv format.

Backup Syntax

Backup SQL Server Databases with a Windows PowerShell Script

In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups

How to identify when a database was restored, the source of the backup and the date of the backup

After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.