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

Scripts with tag Backup / Restore Rss

Search for any content tagged backup / restore

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 40 of 210    Older >>
 

Copy/Refresh a database in the night

Refresh a report database with this script.  Read more...
By Jason S Wong 2010/07/16 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,497 reads

Custom cleanup procedure for backup files

There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.   Read more...
By Roshan Joe Joseph 2009/11/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,440 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,970 reads

Backups daily monitoring

This script finds the last run status for Full / TL backups.  Read more...
By Arun Jebakumar 2009/09/04 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,210 reads

Backup Both Full and TLog Database Backup within a single Job

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.  Read more...
By Nitin Gupta 2009/08/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,592 reads

Backup Report

A handy script for DBAs to find the last healthy backup of a database.  Read more...
By Vijendran R 2010/11/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,775 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 2010/05/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,765 reads

Differential Backup Store Procedure for SQL Server 2000

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.  Read more...
By Swapnil Tawde 2009/07/14 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 719 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: |  Discuss |   Briefcase | 2,260 reads

Zip Backups and Copy to Secondary (free)

We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.   Read more...
By Jeff Bennett 2009/06/18 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,294 reads

Custom Maintenance Plans - the T-SQL way

The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.  Read more...
By Mark Marinovic 2013/05/16 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 3,246 reads

SQL Server Database Backup Status

Lists the Databases and their Backups status in a neatly formatted HTML Email  Read more...
By Pratap Prabhu 2009/05/19 | Source: SQLServerCentral.com | Category: sp_send_dbmail
Rating: |  Discuss |   Briefcase | 2,334 reads

Automate Test Database Restoration

Automate test database restorations from your production system.  Read more...
By Mike Kober 2013/04/05 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,577 reads

Check Syntax on a Database

This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008  Read more...
By Stephen Schaff 2009/04/21 | Source: SQLServerCentral.com | Category: syntax check
Rating: |  Discuss |   Briefcase | 873 reads

Backup on the fly based on previous backups

This script uses the system backup history to run a differential backup and place it in the directory of the last full backup.  Read more...
By jack-311987 2009/03/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 620 reads

Deleting old files (with/without archive bit)

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...
By Gaby Abed 2009/01/01 | Source: SQLServerCentral.com | Category: archive
Rating: |  Discuss |   Briefcase | 1,843 reads

Get Data, Log, Backup, and Binn Directory (SQL Server 2005)

Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005  Read more...
By Cowboy DBA 2008/12/15 | Source: SQLServerCentral.com | Category: data path
Rating: |  Discuss |   Briefcase | 1,601 reads

Backup and Truncate Transaction Logs

Save the transaction log and truncate the file to prevent Tlogs FULL Error  Read more...
By Jorge Novo-@ETLDEVDBA 2008/12/16 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,652 reads

Generate CREATE DATABASE FOR ATTACH for all databases on server

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.  Read more...
By Wesley Brown 2008/12/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,243 reads

Backup And Restore Remain Time

Script to found out how much time before Restore or Backup Process remain  Read more...
By Jorge Novo-@ETLDEVDBA 2008/11/17 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,034 reads
<< Newer    Items 21 to 40 of 210    Older >>