Restore With Standby
by Brent Ozar
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.
In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.
The scripts and related links for this podcast are:
- Restore With Standby Tutorial – article in the wiki with the demo scripts.
- SQL Server Backup & Restore Basics – explains full backups, transaction logs, and the different recovery options.
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later:
Share this post with friends
