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

Content with tags Editorial, Backup / Restore Rss

   Items 1 to 20 of 24    Older >>
 

How Often Do I Backup my Log?

Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.  Read more...
By Steve Jones 2014/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 193 reads

Mongo Jumbo Backups

Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.   Read more...
By Tony Davis 2014/02/03 | Source: SQLServerCentral.com | Category: database weekly
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

Risky Backups

Steve Jones talks about the potential risk issues of multiple backups in one file.  Read more...
By Steve Jones 2013/10/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 317 reads

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2013/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 302 reads

Replace existing Database? JFDI!

Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" natureā€¦  Read more...
By Tony Davis 2012/04/02 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

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

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

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

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

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

Crash and Burn

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...
By Steve Jones 2009/12/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 155 reads

Why Is It Complicated?

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...
By Steve Jones 2009/11/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Protection Close To Home

For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.  Read more...
By Steve Jones 2009/08/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Backup to the Cloud - No Excuses

With the proliferation of high availability & specialist online Backup companies, do we really have any excuses left to NOT have an offsite backup location, even if it is in the Cloud? Brad things not...  Read more...
By Brad McGehee 2009/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2013/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 302 reads

Downtime

One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.  Read more...
By Steve Jones 2009/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 275 reads

Do You Verify Your Database Backups?

Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.  Read more...
By Brad McGehee 2009/02/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 696 reads
   Items 1 to 20 of 24    Older >>
 
Tags
database weekly (2)    
disaster recovery (dr) (2)    
cloud services (1)    
data retention (1)    
dba (1)    
downtime (1)    
friday poll (1)    
legal issues (1)    
raid (1)    
security (1)    
w h (1)    
windows home server (1)