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

Articles with tag backup / restore Rss

Search for any content tagged backup / restore

<< Newer    Items 41 to 60 of 189    Older >>
 

The Institute for Backup Trauma

Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.  Read more...
By Steve Jones 2010/12/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Setting SQL Server Default Locations

How to set the default locations for backups, data files, and log files in SQL Server.  Read more...
By Wayne Sheffield 2010/11/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 5,460 reads

Restore from LiteSpeed

Learn how to restore a LiteSpeed backup on a server without the software in 2 Simple Steps.  Read more...
By Sarvesh Singh 2010/10/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 4,631 reads

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...
By Philip Horan 2013/09/20 (first published: 2010/10/05) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 15,841 reads

Fooling SQL Server

Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.  Read more...
By Steve Jones 2010/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 455 reads

Backup Isn't Enough

When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.  Read more...
By Steve Jones 2010/07/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 304 reads

Lost Data

Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.  Read more...
By Steve Jones 2010/07/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Archive Backups

The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.  Read more...
By Steve Jones 2010/06/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 211 reads

Statistical Sampling for Verifying Database Backups

A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.   Read more...
By Additional Articles 2010/06/01 | Source: SimpleTalk | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,315 reads

Transaction Log Growth, do you need it?

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.  Read more...
By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 32,229 reads

Backup SQL Server to Amazon S3 with CloudBerry Backup

In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.  Read more...
By Pavel Bondarchuk 2010/05/13 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,856 reads

SQL Server 2008 Compression

Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.  Read more...
By Jason Shadonix 2010/04/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 7,380 reads

Rolling Back a Restore

Should rolling back a restore be an option for SQL Server? Steve Jones talks about the possibilities in today's editorial and where it might come in handy.  Read more...
By Steve Jones 2010/03/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 146 reads

Corruption Recovery Tips, Database Shrinkage Advice and More

Question: My backup strategy is a daily full backup at 1 a.m. and a log backup every hour. A DBCC CHECKDB also runs every day at 4 a.m. If I get to work at 8 a.m. and discover that the nighttime consistency checks found extensive corruption, how can I recover without losing a lot of data?  Read more...
By Additional Articles 2010/02/19 | Source: TechNet Blogs | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,151 reads

Striping SQL Server Database Backups

As databases get larger, the time for database backups to complete grows as well. Unfortunately, the time window for your backups may not increase. It could very well be the case that you reach a point where your backups will not finish in a specified amount of time.  Read more...
By Additional Articles 2010/02/18 | Source: MSSQLTips.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,589 reads

Safety in Numbers

One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.  Read more...
By Steve Jones 2010/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Performing SSAS Database Backup

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in...  Read more...
By Bru Medishetty 2010/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,313 reads

Why Can't We Go Backwards?

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...
By Steve Jones 2010/01/13 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 1,074 reads

Why Can't We Go Backwards?

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...
By Steve Jones 2010/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Why Can't We Go Backwards?

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...
By Steve Jones 2010/01/13 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 987 reads
<< Newer    Items 41 to 60 of 189    Older >>