SQLServerCentral.com Scripts tagged Restore

Restore Latest Backup with Powershell

Tue, 16 Apr 2013 06:00:00 UT

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

Restore all of the log file from a folder

Fri, 02 Sep 2011 06:00:00 UT

Restore all of the log file from a folder

SQL DBAdmin toolbox - Part 1: Restore single database

Fri, 10 Jun 2011 06:00:00 UT

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.

Restore point in time

Fri, 14 Jan 2011 07:00:00 UT

Useful script for point in time recovery

T-Log Backup/Restore with Date & Time

Wed, 29 Dec 2010 07:00:00 UT

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

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Fix all orphaned users in a database

Wed, 24 Nov 2010 07:00:00 UT

Fix orphaned users on a restored db

Restore All Backups

Wed, 30 Jun 2010 06:00:00 UT

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

Automated T-Log Restore

Mon, 16 Aug 2010 06:00:00 UT

Sequential transaction log restore

Backup & Restoration Script

Wed, 04 May 2011 06:00:00 UT

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

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Restore Database from network location

Tue, 11 May 2010 06:00:00 UT

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

Script to find latest backups for all databases

Wed, 01 Jul 2009 06:00:00 UT

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Automatically Restore Backup Files for SQL 2005

Wed, 31 Dec 2008 07:00:00 UT

This script helps with restoring backup files SQL Server 2005

Generate CREATE DATABASE FOR ATTACH for all databases on server

Thu, 18 Dec 2008 07:00:00 UT

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.

Backup And Restore Remain Time

Mon, 17 Nov 2008 07:00:00 UT

Script to found out how much time before Restore or Backup Process remain

Restore database with all necessary files

Wed, 13 Jul 2011 06:00:00 UT

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