Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.

Restore All Backups

This is a script to restore all databases from backups places in a folder.

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events

Restore

Generate Restore script for multiple databases

Restore script for moving databases from prod to dev with different path / logical name etc.

Restore script genrator for moving dbs

usefull script for moving databases from one server to another

Script to Restore Entire database from a directory

Script to restore the entire databases from the backup directory just by passing the backup directory.

Script to Get the Database Restore history

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

Backup/Restore

SQL Server Database RESTORE WITH MOVE or not WITH MOVE

Mike Eastland frequently restores production databases to various development servers. The drive layouts between the servers are almost never the same. He is constantly shuffling files on his development servers due to space constraints, which in turn breaks the automated restore scripts because the MOVE clauses are invalidated. Does he have to use the MOVE clause every time he does a restore?