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

Articles with tag Restore Rss

Search for any content tagged restore

   Items 1 to 15 of 15   

SQL Azure Point-in-Time Restore

Point-in-Time Restore is a new feature of the SQL Azure Service Tiers  Read more...
By Paul Hebhardt 2014/10/14 | Source: | Category: sql azure
Rating: |  Discuss |   Briefcase | 1,309 reads

Verify SQL Backup Integrity

Perform automated database restores and check the integrity of your backup files  Read more...
By Willem Gossink 2014/08/11 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 4,074 reads

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events  Read more...
By Brian Awe 2014/06/10 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 3,062 reads

Who Truncated That Table & What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2014/06/05 | Source: | Category: truncate
Rating: |  Discuss |   Briefcase | 13,344 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 5,508 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,320 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,283 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,822 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 | 265 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,757 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 | 11,299 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,442 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,894 reads


What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.  Read more...
By Charles Kincaid 2009/09/30 | Source: | Category: backup / restore
Rating: |  Discuss |   Briefcase | 9,470 reads

Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005

In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?  Read more...
By Additional Articles 2008/12/31 | Source: | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,232 reads
   Items 1 to 15 of 15