SQL Server Performance

Clustering and Database Restoration

Discussion in 'SQL Server 2005 Clustering' started by rajantonyv, Jan 21, 2007.

  1. rajantonyv New Member

    I am new to clustering and SQL 2005. I am in the process of reading up on this topic and had a question about restoration. How does the database restoration on a cluster if a database gets corrupted? Do you have to do anything special.

    Also where can I get more information on restoring a node if one of the node fails? Or how i reinstate a node if it fails?

    Thank you
  2. MohammedU New Member

    If the database is corrupt need to restore from the previous good backup...it is the same for cluster and non cluster servers...

    If there is any issue SQL server will failover to other node and you need to fix the node based on the issue you got...

    SQL Server 2005 Failover Clustering White Paper
    http://www.microsoft.com/downloads/...dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

    SQL Server 2005 Books Online
    How to: Create a New SQL Server 2005 Failover Cluster (Setup)
    http://msdn2.microsoft.com/en-us/library/ms179530.aspx


    Mohammed U.
  3. satya Moderator

    True and there is nothing much difference apart from providing high-availability on a server wide using cluster, as far as the database administration tasks are concerned no change is expected.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page