Home > Ask the Storage Technology Experts > Backup/Recovery Questions & Answers > SQL2000 availability and recovery
Ask The Storage Expert: Questions & Answers
EMAIL THIS

SQL2000 availability and recovery

Jim Booth EXPERT RESPONSE FROM: Jim Booth

Pose a Question
Other Storage Categories
Meet all Storage Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 28 June 2001
We are trying to provide highly available, quickly recoverable SQL2000 databases on a W2K advanced server. We are using MSCS to tackle the availability angle but are currently in a quandary over quick recoverability with, in particular, site failure in mind. Are you able to describe best practices in for both availability and recoverability? I note that Microsoft is advocating stretched clusters to provide the recoverability but I think this space is immature and poses a high level of risk.

>

Since your main concerns are availability and recoverability, I suggest using a mirrored/Business Continuance Volume (BCV) configuration. The mirrored protection (RAID-1) will provide you with the highest level of availability and performance.

The BCV is a logical hardware mirror that can be synchronized and split from the primary mirrored volumes to provide little to no disruption in your database during backup. Yes, you will need more storage but if you do run into a problem and need to restore the last backup you are restoring from disk, not tape. You can also create multiple BCVs to provide multiple backup copies. Before a new backup is required, the BCV data can be moved to tape for long-term storage.

When configuring your storage subsystem mirror the primary volumes. Then, set aside enough standard devices to use as BCVs. Since the BCV is a standard logical device, you can mix and match drives. You might want to spread your database across more 36GB drive spindles and use more cost-effective 73GB drives for the BCVs.

Several manufactures including EMC ( http://www.emc.com/), IBM ( http://www.ibm.com/) and HDS ( http://www.hitachi.com/) offer this BCV option on their hardware platforms. The BCV products fall under the trade names of TimeFinder, SnapShot and ShadowImage respectively. Check their Web sites for the latest innovations.


BROWSE BY TAG
Backup/Recovery,   VIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Backup/Recovery
Troubles with burning software
Running a second daily backup
Remote data software
Using NetBackup with different servers
Different types of disasters and how to protect your data
Contact vendor for error message troubleshooting
What about consolidating data tape to tape?
Are people backing up data to a mainframe?
Five golden rules for backup
Explaining the essence of disk-to-disk backup and its advantages

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Search for Data Management Tools
TechTarget Storage Media
Storage Magazine View this month\\'s issue and subscribe today.
Storage Decisions Apply online for free conference admission.
SearchStorage.com
HomeNewsMagazineTopicsLearningMultimediaWhite PapersBlogsEventsAbout Us

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts