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

Scripts with tag Backup Rss

Search for any content tagged backup

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 21    Older >>

Upload Backup Files to Amazon S3

This script will upload the latest backup files to an AWS S3 bucket  Read more...
By Alex Marsh 2014/11/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 423 reads

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.  Read more...
By shuvo 2014/09/02 | Source: | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,077 reads

Avoid Transaction Logs volume from filling

Script for preventing the volumes of the transaction logs from filling.  Read more...
By Daniel Marques 2014/07/02 | Source: | Category: transaction logs
Rating: |  Discuss |   Briefcase | 2,255 reads


with this below script so you don't need to enable cmdshell..  Read more...
Rating: |  Discuss |   Briefcase | 857 reads

backup, differental and transactions

Backup all databases for an instance (complete, Differential or log of transactions)   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 957 reads

DBCC,Backup, Verify and create Agent Job to restore

Script to Automatically Backup, Drop and create Agent Job to restore from that backup.  Read more...
By Rob Sewell 2014/03/25 | Source: | Category: rationalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 916 reads

To check the full backup duration of an SQL Instance

This script will check the full backup time taken by all the databases of an SQL Server instance.  Read more...
By Shashikant Shakya 2014/01/13 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,232 reads

Display Databases with X days without backup

Displays the information of the date of the latest backup that was done back to @daysago. When value is -0 it gives you all the backup information. The script also gives information on databases that never have been backed up.  Read more...
By Gonzalo Moles 2013/09/20 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,321 reads

Restore multiple db's to new server with new file locations

Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.  Read more...
By Steven Webster 2013/09/10 | Source: | Category: backupset
Rating: |  Discuss |   Briefcase | 1,204 reads

How Long Backups Will Take

When you are running a backup or a restore, this script gives you an estimate of completion time.  Read more...
By Miguel Quintana 2013/06/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,427 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's 
By Theo Ekelmans 2013/03/28 | Source: | Category: automatic
Rating: |  Discuss |   Briefcase | 1,422 reads

Backup history details EMAIL (past 24 hours) in HTML format

Get backup status email daily to your inbox in HTML format.   Read more...
By Venugopal Saride 2013/03/27 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,420 reads

Dynamic Transaction Log Backup

Backup up all transaction logs based on sys.databases. 
By Mitch Spruill 2012/11/16 | Source: | Category: log
Rating: |  Discuss |   Briefcase | 946 reads

Dynamic Database Backup

Backup up all databases based on sys.databases. 
By Mitch Spruill 2012/11/21 | Source: | Category: dynamic
Rating: (not yet rated) |  Discuss |   Briefcase | 955 reads

Last Backup Taken, or Not

Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.  Read more...
By Jon Morisi 2012/05/24 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,421 reads

A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.  Read more...
By James Marsh 2012/05/14 | Source: | Category: sa
Rating: |  Discuss |   Briefcase | 918 reads

Task Progress

Query to check estimated time of a task completion. Viz, alter index, backup, restore, etc.  Read more...
By Adarsh Chillagatta 2012/04/10 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,307 reads


I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.   Read more...
By Lucas Souza 2011/10/17 | Source: | Category: job
Rating: |  Discuss |   Briefcase | 419 reads

NetApp Dynamic Backup Script

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases  Read more...
By Chris Taylor 2011/08/09 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 735 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: | Category: restore
Rating: |  Discuss |   Briefcase | 1,442 reads
   Items 1 to 20 of 21    Older >>