Solved

File Server Resource Manager in a SQL Cluster

Posted on 2014-02-17
3
419 Views
Last Modified: 2014-03-18
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
Comment
Question by:Crossroads305
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Mahesh earned 500 total points
ID: 39865260
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
 
LVL 1

Author Comment

by:Crossroads305
ID: 39865635
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
 
LVL 35

Expert Comment

by:Mahesh
ID: 39866676
No Problem.

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

Mahesh
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
lync 2013 7 54
Monitor vmware windows vm status of services 9 69
How to upgrade SCCM 2012 r2 to SCCM 2016 4 56
How to do advance search in Windows 2008? 11 37
OfficeMate Freezes on login or does not load after login credentials are input.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now