• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

File Server Resource Manager in a SQL Cluster

Hello

I have successfully used File Server Resource Manager in the past. It is a useful tool. I recently attempted to configure FSRM in a SQL Cluster environment. We have two servers in the Cluster. How can I configure quotas when the drives are only on the primary server in the cluster? If I configure quotas on the primary server things work fine until a fail-over occurs. Once we have a fail over all the drives disappear and are then mapped to the second server in the cluster. It seems like once the drives disappear the quotas disappear with them.

How can permanently have quotas in a clustered environment?

Thanks
0
Crossroads305
Asked:
Crossroads305
  • 2
1 Solution
 
MaheshArchitectCommented:
This is what expected in cluster environment in case of file server clusters.

I believe all FSRM enable Quota folders are residing on shared storage drives (Drives that are accessible to both servers) ?

If one server gets shutdown \ failover, all drives including quota config, file screening access rules, reports get migrated to another server

Because your disks are cluster resources and all associated \ dependent attributes\resources to these disks will also get migrated when failover occurs

Mahesh
0
 
Crossroads305Author Commented:
Mahesh

Thank you very much. I should have noticed that myself. Sorry for the stupid question. I just verified that you are correct.

Thanks
0
 
MaheshArchitectCommented:
No Problem.

Since this is active \ passive cluster, this is expected behaviour.

Mahesh
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now