Post reply

Best Practice to Shutdown a SQL Server Cluster 2005 Connected to a SAN

  • November 7, 2007 at 9:15 am

    #176745

    We have a SQL Cluster consisting of two nodes with SQL 2005 SP2 installed on Windows Server 2003 using a SAN. This weekend they will be physically relocating the SAN in our computer room so will need to shutdown completely. I'm looking for best practices of how to accomplish this task. Should I logged into each server and shutdown manually? They expected that the move will take at least 3 hours.

    In addition of SQL backups, what other type of backup should we perform? This is our first and only cluster server. Any advice or pointer to a white paper is appreciated.:hehe:

  • November 7, 2007 at 6:26 pm

    #749297

    Take full backups of all databases and make sure SQL Server verifies them. Probably wouldn't hurt to script the logins as well:

    How to transfer the logins and the passwords between instances of SQL Server 2005

    When we did something similar, we took the SQL Server resource groups off-line using Cluster Administrator. Then we powered off the physical servers one at a time. When we were done, we brought the servers up one at a time and confirmed we could bring the drive resources online prior to even attempting to start SQL Server back up.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply