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

Content with tag Backup Rss

   Items 1 to 20 of 59    Older >>
 

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 | 478 reads

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 | 467 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 136 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 | 441 reads

Stop Relying on Cloud File Stores as a Backup Strategy

There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.  Read more...
By Additional Articles 2014/11/06 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 8,661 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,820 reads

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: SQLServerCentral.com | Category: integers
Rating: |  Discuss |   Briefcase | 4,323 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,105 reads

Verify SQL Backup Integrity

Perform automated database restores and check the integrity of your backup files  Read more...
By Willem Gossink 2014/08/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 4,096 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,299 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 | 861 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,820 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 | 964 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 5,516 reads

SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.  Read more...
By Additional Articles 2014/04/15 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 6,239 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 | 929 reads

Automating the Retrieval of SQL Backups from Windows Azure BLOB Storage

If your database server is in Azure, then it makes sense to do backups into Azure too. SQL Server 2014 supports backups to the cloud, and particularly well with Managed Backup. Once your backups are safely in an Azure BLOB, then what? Mike Wood takes up the story.  Read more...
By Additional Articles 2014/03/24 | Source: SimpleTalk | Category: windows azure
Rating:  Rate this |   Briefcase | 1,645 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/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,820 reads

Backup to the right location, by default

How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.   Read more...
By Additional Articles 2014/01/30 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,376 reads
   Items 1 to 20 of 59    Older >>
 
Tags
backup (49)    
restore (10)    
administration (5)    
powershell (4)    
backup / restore (3)    
transaction logs (3)    
t-sql (3)    
sql server 2008 (2)    
sql server 2014 (2)    
agent job (1)    
amazon (1)    
analysis services (ssas) (1)    
automatic (1)    
automation (1)    
aws (1)    
azure (1)    
backup / recovery (1)    
backup history (1)    
backup verification (1)    
backups (1)    
backupset (1)    
books (1)    
change password (1)    
change sa (1)    
compress (1)    
copy backup (1)    
daily dba task (1)    
database (1)    
dbcc (1)    
delete old backup files (1)    
differential (1)    
disaster recovery (dr) (1)    
dynamic (1)    
dynamic script to copy backup (1)    
editorial (1)    
email (1)    
file operations (1)    
files (1)    
filter backup (1)    
friday poll (1)    
full (1)    
full backup status (1)    
full drive (1)    
index dm_exec_requests (1)    
index maintenance (1)    
integers (1)    
integrity check (1)    
job (1)    
latest backup (1)    
log (1)    
migration (1)    
move (1)    
move files (1)    
netapp (1)    
password (1)    
rationalisation (1)    
recovery model (1)    
red gate software (1)    
remove old backup from path (1)    
replication (1)    
s3 (1)    
sa (1)    
salesforce (1)    
san (1)    
simple-talk series (1)    
smo (1)    
snapmanager for sql (1)    
sql agent (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 7 (1)    
sqlcmd (1)    
statistics (1)    
striped backups (1)    
survey (1)    
time (1)    
transactions (1)    
verify (1)    
windows azure (1)