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

   Items 1 to 20 of 210    Older >>
 

Delete old backup

Delete old backup files on a prespecified folder.   Read more...
By Matimba Maluleke 2012/07/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,269 reads

Find Latest Backup

Finds the last full backup file stored in a given folder.  Read more...
By Carolyn Richardson 2011/08/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,079 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: |  Discuss |   Briefcase | 1,442 reads

Mask PII data (Personally Identifiable Information)

When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.  Read more...
By Sylvia Moestl Vasilik 2011/06/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,064 reads

Backup all databases & check backups

Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups  Read more...
By Pavle-192195 2011/05/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,816 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By S M 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,387 reads

Dynamically Script Database Backups

Dynanically Generate Backups with Date and time  Read more...
By shanu hoosen 2011/02/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,888 reads

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.   Read more...
By Bharat Panthee 2011/01/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,971 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: |  Discuss |   Briefcase | 1,318 reads

Script: Map Orphan Login and Users

Map the Orphan Login and Users.  Read more...
By S M 2011/01/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,595 reads

After Restoring MSDB perform the following two steps

This script has two essential Steps after restoring MSDB  Read more...
By K.senthilkumar 2010/09/21 | Source: SQLServerCentral.com | Category: msdb
Rating: |  Discuss |   Briefcase | 1,921 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
By Gregory Ferdinandsen 2010/08/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,036 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,165 reads

Backup by datetime file name

An example script to show how you backup database by the datetime file name  Read more...
By Jason S Wong 2010/07/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,864 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: |  Discuss |   Briefcase | 2,541 reads

Database State and Backup Information

Displays the current database state, the last backup taken, it's size, and days since the backup.  Read more...
By Henrico Bekker 2010/04/22 | Source: SQLServerCentral.com | Category: days since last backup
Rating: |  Discuss |   Briefcase | 2,217 reads

Backup or Restore progess

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.  Read more...
Rating: |  Discuss |   Briefcase | 2,321 reads

Automated SQL Job to Backup Database(s)

Automate All Database Backups with this script. handle full, diff, and log backups.  Read more...
Rating: |  Discuss |   Briefcase | 2,595 reads

Enterprise wide Backup Audit

Enterprise wide Backup Audit that produces backup information in a csv format.  Read more...
By Pradeep Singh 2010/08/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,778 reads

Find backup set

When you need to know where your backup files are and the timing.  Read more...
By Jason S Wong 2009/11/24 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 877 reads
   Items 1 to 20 of 210    Older >>