Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Automatically Restores All database .BAK Files

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

Total article views: 10157 | Views in the last 30 days: 72
Related Articles

Backup & Restoration Script

This script provides very useful information about database backup and restoration.


Restore Script Generator

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.


Differential Restore

SQL Differential Restore Script


Script to Get the Database Restore history

Script to get the Database restore history details including with the files by which the database is...


restore from script file

I have generated script file from database1 as "database1.sql file" and want to restore database 2


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones