Solved

File Server Resource Manager in a SQL Cluster

Posted on 2014-02-17
3
414 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
Comment Utility
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
Comment Utility
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
Comment Utility
No Problem.

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

Mahesh
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

I have been working as System Administrators since 2003. I recently started working as a FreeLancer and was amazed to find out that very few people are taking full advantage of their Windows Server Machines. Microsoft Windows Server comes with so…
To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

743 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

19 Experts available now in Live!

Get 1:1 Help Now