Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Restore Rss

   Items 1 to 20 of 41    Older >>

DBCC,Backup, Verify and create Agent Job to restore

Script to Automatically Backup, Drop and create Agent Job to restore from that backup.  Read more...
By Rob Sewell 2014/03/25 | Source: | Category: rationalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 715 reads

Script to Restore Entire database from a directory

Script to restore the entire databases from the backup directory just by passing the backup directory.  Read more...
By sathish siva 2014/03/20 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 1,406 reads

Script to Get the Database Restore history

Script to get the Database restore history details including with the files by which the database is restored.  Read more...
By sathish siva 2014/03/17 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 783 reads


By free mascot 2014/02/21 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,932 reads


Mike Eastland frequently restores production databases to various development servers. The drive layouts between the servers are almost never the same. He is constantly shuffling files on his development servers due to space constraints, which in turn breaks the automated restore scripts because the MOVE clauses are invalidated. Does he have to use the MOVE clause every time he does a restore?  Read more...
By Additional Articles 2013/12/05 | Source: | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,218 reads

What is your default database set to?

Some people set their default database to the database they use most often. This can cause issues when a restore fails.  Read more...
By Ben Kubicek 2013/11/14 | Source: | Category: default database
Rating: |  Discuss |   Briefcase | 7,216 reads

Database Restore Automation

Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.  Read more...
By Paul Brewer 2013/11/04 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 4,603 reads

Restore multiple db's to new server with new file locations

Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.  Read more...
By Steven Webster 2013/09/10 | Source: | Category: backupset
Rating: |  Discuss |   Briefcase | 1,098 reads

Find Default Data and Log File Paths

A function to wrap Alex Aza's "find default paths" solution.   Read more...
By Will Spurgeon 2013/07/19 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 568 reads

Restore Script Generator

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.  Read more...
By Jim Youmans 2013/06/18 | Source: | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,486 reads

How Long Backups Will Take

When you are running a backup or a restore, this script gives you an estimate of completion time.  Read more...
By Miguel Quintana 2013/06/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,368 reads

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.  Read more...
By Luke Losli 2013/04/16 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 872 reads

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...  Read more...
By Wayne Sheffield 2013/03/04 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,508 reads

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.  Read more...
By Dewey Wu 2012/09/04 | Source: | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads

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.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,740 reads

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.  Read more...
By Shawn McGehee 2012/03/26 | Source: | Category: books
Rating: |  Discuss |   Briefcase | 10,891 reads

Faster Restores: Best Practices to Increase Speed

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...
By Additional Articles 2011/12/14 | Source: SimpleTalk | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 6,353 reads

Restoring a SQL Server Database – A Practical Example

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...
By Additional Articles 2011/12/09 | Source: SQL Server Performance | Category: restore
Rating:  Rate this |   Briefcase | 3,836 reads

Restore all of the log file from a folder

Restore all of the log file from a folder  Read more...
By lj zither 2011/09/02 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 827 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 4,198 reads
   Items 1 to 20 of 41    Older >>
backup / restore (12)    
backup (7)    
administration (4)    
powershell (3)    
log (2)    
sql server 2005 (2)    
transactions (2)    
t-sql (2)    
agent job (1)    
backupset (1)    
blogs (1)    
books (1)    
connection properties (1)    
copy_only (1)    
dbcc (1)    
default database (1)    
defaults (1)    
disaster recovery (dr) (1)    
log file (1)    
move files (1)    
orphaned users (1)    
pointintimerecovery (1)    
rationalisation (1)    
read only (1)    
recent backups (1)    
restores (1)    
simple-talk series (1)    
sql agent (1)    
sql server 2008 (1)    
sql server 2012 (1)    
sql server 7 (1)    
time (1)    
t-log (1)    
verify (1)    
with move (1)