Find Default Data and Log File Paths

A function to wrap Alex Aza's "find default paths" solution.

Restore Script Generator

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.

How Long Backups Will Take

When you are running a backup or a restore, this script gives you an estimate of completion time.

Restore Latest Backup with Powershell

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

A Month of PowerShell – Day 22 (Restores)

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

T-SQL Restore Script Generator

A procedure that generates point in time restore database & log commands for your databases.

Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent

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.

Script to construct a restore/recovery script

Constructs a restore script for all databases on the server from backup history.

Simplified Restores with SQL Server 2012 Recovery Advisor

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.

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.

• Download free eBook
• Printed book:
  • US
  • UK
• Kindle book:
  • US
  • UK