SQLServerCentral: Content tagged Restore

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Content with tag Restore

Items 1 to 20 of 25 Next 20 >>

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 | 3,143 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,440 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: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 594 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 0001/01/01 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 3,447 reads

SQL DBAdmin toolbox - Part 1: Restore single database

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

By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 1,207 reads

Backup & Restoration Script

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

By Ashish Gilhotra 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 4,234 reads

Restore point in time

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

By Parag Tengshe 2011/01/14 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 1,218 reads

T-Log Backup/Restore with Date & Time

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

By S. Kusen 2010/12/29 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Briefcase | 989 reads

Can the Secondary files in a database be taken offline?

By Nakul Vachhrajani 2010/11/29 | Category: restore

Rating: (not yet rated) |

Briefcase | 2,424 reads

Fix all orphaned users in a database

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

By Harsha Majety 2010/11/24 | Source: SQLServerCentral.com | Category: orphaned users

Rating:

|

Briefcase | 2,188 reads

Automated T-Log Restore

Sequential transaction log restore Read more...

By Tony Savoie 0001/01/01 | Source: SQLServerCentral.com | Category: t-log

Rating:

|

Briefcase | 2,120 reads

Restore All Backups

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

By Disney Hammerschmidt 2010/06/30 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 1,737 reads

Restore Database from network location

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

By Jano Petras 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Briefcase | 2,516 reads

Backups

By Lynn Pettis 2010/04/30 | Category: backup / restore

Rating: (not yet rated) |

Briefcase | 3,274 reads

Automated T-Log Restore

Sequential transaction log restore Read more...

By Tony Savoie 0001/01/01 | Source: SQLServerCentral.com | Category: t-log

Rating:

|

Briefcase | 2,120 reads

COPY_ONLY Backups

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: SQLServerCentral.com | Category: backup / restore

Rating:

|

Briefcase | 9,287 reads

Backup & Restoration Script

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

By Ashish Gilhotra 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 4,234 reads

Restore Database from network location

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

By Jano Petras 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Briefcase | 2,516 reads

Script to find latest backups for all databases

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

By Roshan Joe Joseph 2009/07/01 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Briefcase | 1,788 reads

Restore of the Database

By free mascot 2009/01/21 | Category: restore

Rating: (not yet rated) |

Briefcase | 3,408 reads

Items 1 to 20 of 25 Next 20 >>