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

Content with tags Backup / Restore, Disaster Recovery (DR) Rss

   Items 1 to 19 of 19   
 

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

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,492 reads

TDE and Backups

Rating: (not yet rated) |  Discuss |   Briefcase | 2,005 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

7 Ways To Crash a Database

Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.   Read more...
By Additional Articles 2009/08/27 | Source: Database Journal | Category: backup / restore
Rating:  Rate this |   Briefcase | 9,212 reads

Zip Backups and Copy to Secondary (free)

We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.   Read more...
By Jeff Bennett 2009/06/18 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,225 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

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2009/03/25 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 351 reads

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2009/03/25 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 319 reads

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2009/03/25 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 505 reads

SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery

Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.   Read more...
By Additional Articles 2008/10/20 | Source: DevX | Category: transaction logs
Rating:  Rate this |   Briefcase | 2,724 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,098 reads

Backup Scenarios for successful SQL Server Restores and Recovery

SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.   Read more...
By Bilal Ahmed 2004/06/29 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 17,532 reads

Integrating SQL LiteSpeed in your existing Backup Infrastructure

This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.   Read more...
By Jeremy Kadlec 2003/05/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,347 reads

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Backup and Restore Back to Basics with SQL LiteSpeed

This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.   Read more...
By Greg Robidoux 2002/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,632 reads

Streamlining the Database Server Recovery Process

Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.   Read more...
By Gregory Larsen 2002/11/05 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 8,952 reads

VBScript Classes to Query SQL Server for Backup Information

A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.   Read more...
By Bruce Szabo 2002/08/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,103 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,492 reads
   Items 1 to 19 of 19   
 
Tags
sql server 7 (7)    
strategies (7)    
administration (4)    
availability (2)    
configuring (2)    
editorial (2)    
miscellaneous (2)    
programming (2)    
replication (2)    
7zip (1)    
backup / recovery (1)    
bcp (1)    
common language runtime (clr) (1)    
compression (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
export (1)    
gzip (1)    
log shipping (1)    
product reviews (1)    
reviews (1)    
sql server 2005 (1)    
sqlclr (1)    
sql-dmo (1)    
transaction logs (1)    
transparent data encryption (tde) (1)    
zip (1)