Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...

Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.  Read more...

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.  Read more...

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.  Read more...

Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.  Read more...

Performing a Database Restore is a part of a DBA's daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted media, low disk space on the server and so on. This articlel outlines one approach which can be used to Restore the backup of the Production Database a test environment.  Read more...

Restore all of the log file from a folder  Read more...

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...

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

Useful script for point in time recovery  Read more...

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.  Read more...

Read more...

Fix orphaned users on a restored db  Read more...

Sequential transaction log restore  Read more...

SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'   Read more...

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...

Read more...

Sequential transaction log restore  Read more...