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

Articles with tag backup Rss

Search for any content tagged backup

   Items 1 to 17 of 17   
 

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,691 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,457 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,084 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,541 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,258 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,842 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,735 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 | 221 reads

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...
By Daniel Calbimonte 2012/08/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 6,036 reads

Backups, What Are They Good For?

We've heard the confessional story from Pixar that Toy Story 2 was almost lost due to a bad backup, but sometimes there is no 'almost'. Grant Fritchey casts a sympathetic eye over some catastrophic data losses, and gives advice on how to avoid what he has termed an RGE (résumé generating event).  Read more...
By Additional Articles 2012/05/25 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 3,504 reads

SQL Server Backup and Restore

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Shawn McGehee 2012/03/26 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 11,142 reads

Faster Restores: Best Practices to Increase Speed

Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.  Read more...
By Additional Articles 2011/12/14 | Source: SimpleTalk | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 6,408 reads

Backup Verification: Tips for Database Backup Testing

A Backup system is merely part of a recovery system. If your backups can't be used to recover the database, then they're useless. Do you regularly make sure that you can restore a database from your backups?  Read more...
By Additional Articles 2011/12/12 | Source: SimpleTalk | Category: backup verification
Rating: (not yet rated)  Rate this |   Briefcase | 5,332 reads

Survey: what features do you want from a backup tool?

We’d like your thoughts on what new features should go into our backup tools. Let us know by completing this short survey.  Read more...
By Press Release 2011/12/07 | Source: Red-Gate | Category: survey
Rating:  Rate this |   Briefcase | 1,464 reads

Using PowerShell for SQL Server Transaction Log Backups

How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.  Read more...
By Additional Articles 2011/10/25 | Source: MSSQLCity.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,268 reads

Using PowerShell for SQL Server Database Backups

If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.  Read more...
By Additional Articles 2011/09/30 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,949 reads

Simple Script to Backup All SQL Server Databases

Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.  Read more...
By Additional Articles 2011/08/12 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,149 reads
   Items 1 to 17 of 17