Solved

File Server Resource Manager in a SQL Cluster

Posted on 2014-02-17
3
422 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 36

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 36

Expert Comment

by:Mahesh
ID: 39866676
No Problem.

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

Mahesh
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
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…

770 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