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

<< Newer    Items 21 to 40 of 51    Older >>
 

Microsoft SQL Server Cluster Vs Standby Server

Building a highly available system is hard. This short white paper from Sonasoft shows some of the differences between a cluster and their standby server product.   Read more...
By Bilal Ahmed 2005/10/28 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,266 reads

Minimizing the need to restore a backup

The second installment of this series discussed the cost of maintaining systems with various levels of downtime, ways data can be lost, and what constitutes a backup. In this installment, I discuss how to configure your hardware to minimize the need to restore a backup.   Read more...
By Additional Articles 2005/09/29 | Source: Red-Gate | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,353 reads

How much backup is enough?

How much backup data should you keep around and what are the implications? Part 2 of a series looking at backups and their implications.  Read more...
By Additional Articles 2005/08/30 | Source: Red-Gate | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,572 reads

Running Out of Space

How many times have you run out of space in a database? What about on a file system? Andy Warren has had this happen a few times, especially when large imports take place. He brings us an article that describes some of the precautions he has taken to prevent this from happening.   Read more...
By Andy Warren 2005/07/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,976 reads

The DBA Whoops

Ever do something to your SQL Server 2000 server and then realize you've just broken something major? Ever have a moment when you want to go "whoops", but really feel like crying ot running away? Steve Jones just had one of those and gives you a few things to think about when you deal with a situation like that.   Read more...
By Steve Jones 2005/06/16 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 11,963 reads

Why bother with backup?

Backing up SQL Server data is like many of the things we do because we figure we need to. It is good for you, like eating a good diet and getting exercise. Unfortunately, folks are often about as successful with SQL Server backups as they are with diet and exercise. This is the first in a series of articles covering SQL Server database backup. The series starts from the very basics of why database backup is important. The question of why to backup a database can inform many other decisions.  Read more...
By Additional Articles 2005/05/09 | Source: Red-Gate | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,370 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,892 reads

Clustering SQL Server 2000 from 500 Feet

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.   Read more...
By Brian Knight 2004/11/25 (first published: 2001/07/02) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 68,104 reads

Worst Practice - Detailed Disaster Plans

Another in our series of things you should avoid at all costs. Seems silly at first, not having a detailed recovery plan for your SQL Server. Perhaps it is, but having dealt with any number of problems over the last few years, Steve Jones has some ideas why a detailed plan may not be the best thing to spend your time on.   Read more...
By Steve Jones 2004/11/09 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 7,903 reads

Incident Response - Responding to an Incident

Part 2 of Steve Jones' Incident Response series that looks at how you should be prepared as well as what to do when disaster strikes. Part 1 established a basic framework and part 2 dives deeper into what you might need for the next virus, hardware failure, or hurricane :(.   Read more...
By Steve Jones 2004/10/11 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 4,891 reads

Incident Response - The Framework

Do you have a SQL Server disaster plan? What about something less than a disaster? Steve Jones has worked more than his share of disasters or incidents, some of them self-inflicted. He's taken some of his experience and started a new series looking at a framework for dealing with incidents. Read part 1 about getting prepared.   Read more...
By Steve Jones 2004/08/26 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 6,319 reads

Disaster in the Real World - Hurricane

Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan.   Read more...
By Andy Warren 2004/08/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,253 reads

Using Different Techniques for SQL Server Automation

Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.   Read more...
By Haidong Ji 2004/08/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,300 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,933 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,543 reads

Save Yourself - Recovering from an XP Disaster

How many of you dig into Windows XP extensively? Working with hardware and the OS isn't something that many DBAs deal with these days. Most companies have an admin to work on servers, hardware, workstations, etc. But sometimes you need to help yourself out. Steve Jones had to work to get his laptop back after an XP disaster. Read on and hopefully this will help you one day recover your system.   Read more...
By Steve Jones 2004/06/23 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,865 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,361 reads

Mini Disaster - AC Failure

Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.   Read more...
By Andy Warren 2004/06/07 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 6,107 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,350 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
<< Newer    Items 21 to 40 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)