SQL Server Restore Database Options and Examples

In this article we look at different SQL Server backup types and schedules and the steps to take to properly restore a database.

Getting a database online

Verifying the restore

Transactional Logs Restore

Testing Transaction Logs restore

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?

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.