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

Add a script

   Items 1 to 20 of 210    Next 20 >>
 

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,075 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,021 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,377 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 | 978 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,559 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 Sourav Mukherjee 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,249 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,832 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,920 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,208 reads

Script: Map Orphan Login and Users

Map the Orphan Login and Users.  Read more...
By Sourav Mukherjee 2011/01/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,462 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: backup / restore
Rating: |  Discuss |   Briefcase | 1,842 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 | 975 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,125 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,820 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,171 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,165 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...
By Purushotham Kumar Katakam 2011/07/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,289 reads

Automated SQL Job to Backup Database(s)

Automate All Database Backups with this script. handle full, diff, and log backups.  Read more...
By Venkatesh Krishnamurthy 2009/12/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,492 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,720 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 | 851 reads
   Items 1 to 20 of 210    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.