GenerateFullSequenceRestoreScripts_Litespeed

Sp to Generate Restore sequence

Restoring without CHECKSUM

Restore options

Restoring with CDC

Extremely Quick Backups

PARTIAL Restores

Displaying Backup or Restore Progress

Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.

Extended Events for Tracking Backup and Restore Progress

Microsoft has introduced new extended events in SQL server 2016 which will give us detailed information about restore and backup process.

The Backup Operator

Managing SQL Server Backup and Restore History Information

Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.