DBCC,Backup, Verify and create Agent Job to restore

Script to Automatically Backup, Drop and create Agent Job to restore from that backup.

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?

What is your default database set to?

Some people set their default database to the database they use most often. This can cause issues when a restore fails.

Database Restore Automation

Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.

Restore Database with any number of Ndf files

Execute the code after passing database name on which you want to restore and the path where your backup file being located.
e.g exec sp_restoredb N'mydatabase',N'D:\mydatabase.bak'

Restore multiple db's to new server with new file locations

Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.

SQL Server Backup and Restore

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.