Clustering and Database Restoration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Clustering and Database Restoration

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
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.
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.
]]>