Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Lester Policarpio,
Tired of manually restoration of backup files? then this script is for you. This is an easy way to restore your ".BAK" files. Your .mdf and .ldf will be restore in the same path/directory where it first resides (upon execution of the backup). The time consumed depends on how many your databases are and the sizes of the mdf and ldf files. Upon restoration, you can change the path/directory of the .mdf and .ldf. Before running the script please read carefully the comments written in the script so that you can attain a 100% error free execution
This script provides very useful information about database backup and restoration.
Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.
SQL Differential Restore Script
Script to get the Database restore history details including with the files by which the database is...
Restore script for moving databases from prod to dev with different path / logical name etc.