Post reply

MSDB in a Cluster

  • October 14, 2010 at 7:28 am

    #228057

    Hi all

    If I have a clustered environment but leave the system databases on the local disks of each node, then what if I add a job on while on Node A, does that job also appear if failed over to Node B and if so how does it update MSDB on Node B?

    Thanks

  • October 14, 2010 at 10:03 am

    #1236999

    Ok seems you can't put the system databases on a drive thats not part of the cluster. In that case I have just put them on the SAN disk where the User databases will reside. Can anyone tell me if that is a normal setup?

    Thanks

  • October 14, 2010 at 10:42 am

    #1237043

    In a clustered environment, all SQL databases and any other resources it needs must be on shared drives (drives visible to both cluster nodes)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 15, 2010 at 3:15 am

    #1237369

    In SQL Server 2008 the only system database moved to a cluster node local drive (the SQL Binn directory) is the MSSQLSystemResource database. This is to facilitate, as far as I can remember, removal of SP's and CU's.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 15, 2010 at 9:45 am

    #1237652

    Ok cool thankyou

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

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