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 20   
 

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 Mashrur Shuvo 2014/09/02 | Source: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 687 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,041 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 | 809 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 | 917 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 | 871 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,208 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,265 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,176 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,415 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,343 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,376 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 | 928 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 | 938 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,413 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 | 917 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,303 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 | 418 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 733 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,438 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,391 reads
   Items 1 to 20 of 20