Space Requirement on Cluster Drive

  • I am installing a DEV instance of SQL 2008 R2 64-bit on a Windows 2008 R2 Server configured as a one-node cluster. The reason we are doing a one node cluster is to replicate as much as possible (with one machine) the configuration of the Production server, which will be on a two-node cluster.

    When installing SQL, the pre-install check fails due to the lack of a shared disk. The message says there must be at least one shared cluster disk for Setup to continue.

    Is there any space requirement to the shared disk? I understand that in a 2+ node cluster you'd put your database, log and backup files on shared disks, but in single-node cluster, does SQL have to write anything there at all?

    Dan

  • On a cluster all of the database files have to go on a cluster disk so that they can move between nodes in the event of a failover.

    The size and number of disks depends on the number of and size of the databases you are putting on there.

    If you are just testing you could just use one disk for all of the files

  • Since we're doing one node (for dev) and haven't planned for SAN space for dev, can we get away with adding a small shared disk and storing all the database, log & backfiles on the local drives?

  • I think you will have to add a small SAN disk. Although it is a one node cluster, it is still a cluster and has requirements for the disk configuration

Viewing 4 posts - 1 through 3 (of 3 total)

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