Login or Register

  Welcome: Guest


Home >> Article >> Technology >> Software >> Post New Article Bookmark and Share

Various data recovery methodologies for SQL Server

November 22, 2011  by: Fergal Patton  Points: 12   Category: Software    Views: 578

The various methods for SQL server recovery have been mentioned in this article. They are SQL Server Recovery through Failover Clustering (FC), SQL Server Recovery with Database Mirroring (DM), Peer-to-peer transactional replication method.

         

A severe data crisis with Microsoft SQL server can certainly halt the growth prospects of an organization. Some of the situations resulting into data crisis are fire, network breakdown, manmade disaster or any other technical disaster. Such crisis can be overcome with a little technical knowhow and right knowledge. I will tell you about some of the best recovery options available for SQL server.

SQL Server Recovery through Failover Clustering (FC)

It is a mechanism to failover automatically in case of a hardware or software failure. With this Kernel for SQL Recovery tool a user can evolve a failover cluster for a single or multiple instances of SQL Server 2000. This process can salvage the SQL data from operating system or upgrade failure. FC has been designed specifically with no server downtime for high server availability.

The following Microsoft platforms support the FC mechanism: Windows NT 4.0, Windows 2000 Advanced Server, Windows 2000 Datacenter Server Windows Server 2003, Enterprise Edition, Windows Server 2003 and Datacenter Edition. These systems use the Microsoft Cluster Service (MSCS) for deploying the failover clustering for SQL Server.

Disadvantages of FC

1.This process is very expensive
2.It supports only servers in straight line.
3.FC does not retrieve data from disk array failure.
4.Creating failover clusters at database level or database object level is not possible with this method.

SQL Server Recovery with Database Mirroring (DM)

DM is a software design for increasing database availability and it supports those databases that depend upon full recovery model. Unfortunately, simple yet bulk logged models do not support database mirroring.

Disadvantages of Database Mirroring

1.The primary database being recovered through mirroring should be similar to the principal database.
2.The transfer of information between computers in a network can threaten the security.

Peer-to-peer transactional replication method

This method has been specifically devised for the applications (taking part in replications) that can read or modify the data in any database. If any server hosting the databases is not available then it can be modified with an application to route traffic.

Disadvantages

1.This method is possible only with SQL Server 2005 Enterprise Edition.
2.The participating databases should have the identical schemas and data.
3.Tables and objects in single publication database cannot be included in transactional replication.
4.Conflict Detection or Conflict Resolution is not possible with this method.

Maintenance of warm standby server

A user can maintain the warm standby server with these methods:
Log shipping: Available with Microsoft SQL Server 7.0, Microsoft SQL Server 2000 Enterprise Edition and Microsoft SQL Server 2000 Developer Edition.

Disadvantages

1.The database becomes unusable during the restoration process.
2.It cannot be used to bring or reject the table changes.
3.There is no option available for automatic failover of applications.

Transactional replication: It quickly replicates the data from server (the publisher) to the other with less latency.

Disadvantages

1.Schema changes performed at the publisher will not be available at the subscriber.
2.It uses the Open Database Connectivity (ODBC) connection which is nowhere near the performance of Restore Transaction.

Redundant Array of Independent Disks (RAID)

This tool stores the redundant data on multiple disks for delivering greater speed and less downtime.

Disadvantages
1.This is a lengthy time taking process.
2.Recovering the data from multiple disks fail is not possible with RAID.

Author Bio

The author is an experienced System Administrator. He has mentioned various methods for SQL Server Recovery like: SQL Server Recovery through Failover Clustering (FC), SQL Recovery with Database Mirroring (DM), Peer-to-peer transactional replication method, Maintenance of warm standby server and Redundant Array of Independent Disks (RAID). For more information visit this site: http://www.sqlserverrecovery.org




Comment(s)

No response found. Be the first to respond to this post

Post Comment

Please Log In  to post comment

Related Resources



The Way Raid Data Recovery Works
Before embarking on the mission to steadiness abstracts that have been absent from an accumulator volume, it is exact vital to take a look at and accept the affidavit abaft the twist of fate of the abstracts in the aboriginal place. Arrest abstracts accretion is an analytical adjustment of abstracts accretion during which the abstracts from a declining or broken accumulator average is related and analyzed afore affective the advice in a area through house look to a abstracted house in an arrange

Data Recovery Software Makes Retrieving Of Lost Possible
This article provides you a very informative solution on the concept of recovering a deleted file. It also provides the possibility of data recovery software to recover your file even if it was already emptied from the recycle bin.

Evaluating Concept of Hard Disk Drive for Data Recovery
Data loss due to hard disk drive break down can be remedied at the present. In cases of software troubles, by means of a DIY recovery parcel is the common cure that residence user's way out to.

Verifying the Possibility of Data Recovery to a Hard Disk Drive
Bearing in mind information is so significant and information failure ordinary, it is no speculate that data recovery is in steady command. Data recovery is an exact and thorough process and is most excellent approved out by professionals.

Download data recovery tools for free
Windows hard disk can get corrupted due to various reasons. If it is a software issue then you can possibly get back all your data even if you have formatted your hard disk. Many tools are designed to serve this purpose but make sure you choose the best one for your case.

Latest Resources From The Same Category



Pros and Cons of the New Computer Baby Windows 8
The computer company Microsoft has given birth to the new baby named Windows 8. It is available in the market now. How far it is going to change the computer world is to be decided by the future.

What is Adware and Spyware and How to remove them?
Learn what is adware and spyware and to protect your PC from them and the best free software to help you do it.

List of few important software
List of some cool software which can be helpful to you for your daily task on computer.

Share your internet connection via WiFi
Share your internet connection with more devices using wifi.

Nimbuzz !! Best Socializing tool
Great application for mobile phones and for the social sites loving people.

 

Top Performers     Top Contributors     Share and Earn     Terms of Service    Privacy Policy     Contact Us