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

Content with tags Disaster Recovery (DR), Strategies Rss

   Items 1 to 20 of 51    Older >>
 

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,497 reads

In The Real World - Disaster!

A real world account of disaster recovery. (This article is being republished after the recent hurricane that hit the US East Coast).   Read more...
By Steve Jones 2012/12/12 (first published: 2002/04/22) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,620 reads

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...
By Paul Ibison 2008/06/27 (first published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 59,255 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,884 reads

13 disasters for production web sites and their solutions

Learn about 13 production disasters that can bring down your business  Read more...
By Additional Articles 2007/08/23 | Source: CodeProject.com | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 3,687 reads

Eliminating Tape

In response to an editorial on eliminating tape in favor of disk backups, new author Tim OPry brings us a look at his environment and the process by which they eliminated the need for tape in their backup scheme while maintaining a well thought out disaster plan.   Read more...
By Tim OPry 2007/01/03 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 7,146 reads

Survival of the Prepared: Addressing Disaster Recovery

While no disaster recovery plan provides ironclad protection, your company will be far less vulnerable to an extended business disruption from a disaster with a plan than without one.  Read more...
Rating:  Rate this |   Briefcase | 1,880 reads

Database Snapshots

In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.   Read more...
By Kumar Part 2006/09/21 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 10,373 reads

Copying Database Backups to an Alternative Location

Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.  Read more...
By Additional Articles 2006/09/08 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 4,309 reads

Backup Basics Part 3: General Tips for a Backup Strategy

Knowing how to configure backup applications and select backup media is half the battle of designing a successful backup strategy. The other half is choosing how and when to back up the specific pieces of data that are stored on your servers, share points, and workstations. In this final article of his series on backup basics for new technicians and administrators, Ryan Faas offers some suggestions to help you make these important decisions.  Read more...
By Additional Articles 2006/08/11 | Source: InformIT | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,675 reads

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...
By Paul Ibison 2008/06/27 (first published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 59,255 reads

DBA from Crisis to Confidence

Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It's an on-call function; you never know what might happen  Read more...
By Additional Articles 2006/07/27 | Source: Database Journal | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 3,513 reads

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.   Read more...
By Andy Warren 2006/06/16 (first published: 2001/05/07) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 24,529 reads

Differential Backup Tricks

Differential backups are left out of many DBAs backup strategy, but they are a great tool to shrink your backup window, save disk space, and more. However they can be slightly tricky when you look to perform a restore. New author Qian Ye brings us an interesting issue that occured during differential testing.   Read more...
By Qian Ye 2006/06/14 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 8,216 reads

Achieving Server Redundancy at Remote Offices

Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.   Read more...
By Mark Cook 2006/05/25 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,197 reads

SQL Server 2005 High Availability

Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.   Read more...
By Steve Jones 2006/05/24 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 16,247 reads

Back Up Your Database With USB

Disaster recovery solutions is always a concern with SQL Server and when a new or unique solution comes up, we like to get it out there. New author Kevin Parks brings us a look at his way of using a USB hard drive and Windows PE to ensure recovery.   Read more...
By Kevin Parks 2006/05/18 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 8,698 reads

Business Continuity for SQL Servers With a Standby Approach

Ensuring the availability of your database servers is becoming more important all the time. Fortunately you have more choices than ever. Bilal Ahmed looks at some of the possible solutions available for SQL Server.   Read more...
By Bilal Ahmed 2006/04/26 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,220 reads

Testing SQL Server restores

Testing is key to ensuring a process actually works when it comes time to implement, rather than finding out when time may be of the essence. This holds true for testing SQL Server restores as well.   Read more...
By Additional Articles 2006/04/24 | Source: Other | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,144 reads

SQL Server Redundancy for SMBs

Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.   Read more...
By Bilal Ahmed 2006/02/21 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,658 reads
   Items 1 to 20 of 51    Older >>
 
Tags
sql server 7 (16)    
administration (11)    
backup / restore (7)    
availability (3)    
miscellaneous (3)    
programming (3)    
replication (3)    
sql server 2005 (3)    
configuring (2)    
installation (2)    
product reviews (2)    
reviews (2)    
sql-dmo (2)    
dts (1)    
high availability (ha) (1)    
monitoring (1)    
security (1)