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

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 | 3,827 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 | 718 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,387 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,309 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,042 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,644 reads

Azure SQL Database Backup

By free mascot 2014/01/14 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,356 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,132 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,183 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,098 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,309 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,369 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,184 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,319 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,309 reads

How to Identify and Backup the Latest SQL Server Database in a Series

I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.  Read more...
By Additional Articles 2012/12/03 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 1,711 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 | 897 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 | 884 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,309 reads

Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent

It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.  Read more...
By Dewey Wu 2012/09/04 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads
   Items 1 to 20 of 42    Older >>
 
Tags
restore (7)    
powershell (3)    
t-sql (3)    
backup / restore (2)    
sql server 2008 (2)    
sql server 2014 (2)    
transaction logs (2)    
administration (1)    
agent job (1)    
automatic (1)    
azure (1)    
backup / recovery (1)    
backup history (1)    
backup verification (1)    
backups (1)    
backupset (1)    
books (1)    
compress (1)    
database (1)    
dbcc (1)    
differential (1)    
dynamic (1)    
email (1)    
files (1)    
full (1)    
full backup status (1)    
index dm_exec_requests (1)    
index maintenance (1)    
integrity check (1)    
job (1)    
log (1)    
move (1)    
move files (1)    
netapp (1)    
rationalisation (1)    
recovery model (1)    
red gate software (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)