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

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: SQLServerCentral.com | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 576 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: SQLServerCentral.com | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 860 reads

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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 460 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: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,154 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: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 2,361 reads

Delete_Old_Backu_Files_No_xpcmdshell_needed

with this below script so you don't need to enable cmdshell..  Read more...
Rating: |  Discuss |   Briefcase | 873 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 | 976 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: SQLServerCentral.com | Category: rationalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 944 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,253 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,345 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: SQLServerCentral.com | Category: backupset
Rating: |  Discuss |   Briefcase | 1,212 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,444 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2013/03/28 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 1,481 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,439 reads

Dynamic Transaction Log Backup

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

Dynamic Database Backup

Backup up all databases based on sys.databases.  Read more...
By Mitch Spruill 2012/11/21 | Source: SQLServerCentral.com | Category: dynamic
Rating: (not yet rated) |  Discuss |   Briefcase | 964 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,427 reads

sa_help_rev.erse.sa.login

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: SQLServerCentral.com | Category: sa
Rating: |  Discuss |   Briefcase | 922 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,315 reads

UP_COMPACTA_COPIA

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: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 422 reads
   Items 1 to 20 of 23    Older >>