Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anon1m0us
Starting Member
7 Posts |
 Posted - 2011-09-22 : 13:31:50
|
| I have a two server active/passive Windows 2008 R2 cluster with SQL 2008. I created 8 drives in our SAN for SQL. During the install, SQL created the SQL Resource Group which contains the following:----SQL Server Name---Other resources like SQL Server & SQL Server Agent.--- Disk DrivesDrive 1 - System databasesDrive 2 - User Databases data filesDrive 3 - User Databases log filesDrive 4 - TempdbDrive 5 - MSDTCDrive 6 - QuromDrive 7 - User Databases data2 filesDrive 8 - User Databases log2 filesRight now, SQL Server has a dependency on all the drives and the server name.I just read the following in Technet: "SQL Server resource dependencies: If you add a resource to a SQL Server group and you have a dependency on the SQL Server resource to make sure that SQL Server is available, Microsoft recommends that you add a dependency on the SQL Server Agent resource. Do not add a dependency on the SQL Server resource. To make sure that the computer that is running SQL Server remains highly available, configure the SQL Server Agent resource so that it does not affect the SQL Server group if the SQL Server Agent resource fails." Does this mean I should remove all my resource dependencies; which are disks, from SQL server and add them to SQL Agent?What dependencies should be on SQL server and what should be on SQL Agent? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-09-22 : 17:01:35
|
| SQL Server should depend on Network name, and disk resourcesSQL Server Network name depends on IPSQL Server Agent depends on SQL Server. IP and disks do not depend on anything.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Dependencies