How to Generate a Restore Script

There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?

Restore of database

This script takes path and dbname. You can either print or run the command

Backup Strategy in Azure SQL?

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.

Part 2 -- Restore a database to another instance...

This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.

Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.

Check, Please

Move DB roles

This script will script the role members for all roles on the database.

Scrubbing Personally Identifiable Information

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command

Restore Gene : Automating SQL Server Database Restores

Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.