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

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 | 744 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 | 3,837 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,064 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 | 814 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,397 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 | 919 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,465 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,111 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 | 872 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,556 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,397 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,277 reads

SQL Server 2014 Backup Basics

There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.  Read more...
By Additional Articles 2014/01/16 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,865 reads

Azure SQL Database Backup

By free mascot 2014/01/14 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,403 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,209 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,268 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,178 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,397 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,416 reads
   Items 1 to 20 of 51    Older >>
 
Tags
restore (9)    
powershell (4)    
transaction logs (3)    
t-sql (3)    
administration (2)    
backup / restore (2)    
sql server 2008 (2)    
sql server 2014 (2)    
agent job (1)    
automatic (1)    
automation (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)    
daily dba task (1)    
database (1)    
dbcc (1)    
delete old backup files (1)    
differential (1)    
dynamic (1)    
email (1)    
files (1)    
full (1)    
full backup status (1)    
full drive (1)    
index dm_exec_requests (1)    
index maintenance (1)    
integrity check (1)    
job (1)    
log (1)    
migration (1)    
move (1)    
move files (1)    
netapp (1)    
password (1)    
rationalisation (1)    
recovery model (1)    
red gate software (1)    
sa (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)    
sqlcmd (1)    
ssas (1)    
statistics (1)    
survey (1)    
time (1)    
transactions (1)    
verify (1)    
windows azure (1)