Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

File Server Resource Manager in a SQL Cluster

Posted on 2014-02-17
3
Medium Priority
?
438 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
Mahesh earned 2000 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 37

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
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 configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

719 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