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 |
|
seethem
Starting Member
46 Posts |
 Posted - 2007-08-17 : 11:37:14
|
| Hi All,Background Info====================* 2 - node not in any cluster.* Each with 32G RAM & 8 CPU* Windows Server Enterprise Edn. 2003 SP2* 4 MS SQL Server 2005 Enterprise Edn. Instances on Node1 * 3 MS SQL Server 2005 Enterprise Edn. Instances on Node2* Communicating with its own SANIntention===================* There is an interest from 'upstairs' to cluster the two nodes because of the HA SLA for a couple of the applications.* Additionally they request to carve up the SAN into 2 large RAID5 Arrays and 2 large RAID1 Arrays. * All the Arrays are shared by both nodes.* Each node however would be assigned its own pair of RAID1 and RAID5 for the instance.* Management is also interested in letting each Instance have the following: - RAID5 DATABASE LUN - RAID1 LOG LUN - RAID1 TEMPDB LUN - RAID5 MAINTENANCE PLAN LUNCONCERN============* As the DBA, I believe that the above implementation would have each instance owning 4 drive letters. Question===========* Is it possible to have 1 Large Maintenance Plan LUN for each Node? So that I want all the instances off of Node1 to be sharing the same Drive letter (Z:) for their Maintenance plans. And also all the instances off of Node2 to have 1 large LUN for their maintenance plans, (Y:)?If yes, then I am presuming that during the instance creation that I would not select either drives Z: or Y: to be part of the resource group for that instance.I hope I was lucid in my description. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:09:39
|
| What's purpose of maintenance plan lun? To host backup files? If so, you can let both nodes share it. |
 |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-08-18 : 08:02:01
|
| Hi rmiao,Thanks for the response. Yes, the purpose is only to hold the backup files.Do you recommend that the LUN for the LOGS be the same design, i.e. 1 big LUN for both nodes as opposed to each instance having their own LUN?Thanks & Regards,seethem |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 17:09:52
|
| Instances shouldn't share arrays for db files since you like each instance be owned by different node in the cluster. |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-08-20 : 08:23:01
|
| Hi rmiao or anyone,How then do I get the instance to see the other filesystems? Let me explain...Group 0 had shared storage G:I added shared storage R: to Group 0.Now when I installed the SQL instance, i chose filesystem G: to be the storage area for the installation of the files. I want to backup the databases of this instance to the R: drive but I can't seem to get MS SQL 2005 to see any drive other than the G: drive.Please help! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 22:29:30
|
| You should use unc name like \\virtual_sql_name\share, or add r:\ as sql resource's dependency in cluster admin. |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-08-21 : 05:45:24
|
quote:
Originally posted by rmiao
What's purpose of maintenance plan lun? To host backup files? If so, you can let both nodes share it.
Last one rmiao or anyone, Can you tell me how to let both nodes share this LUN please? or Is there a note on how to do this?Let me let you know my situation, I have x instances on node1 and y instances on node2.I want all of them to be backed up to that one LUN. Is that possible or not?Regards,seethem |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-08-21 : 06:04:42
|
quote:
Originally posted by rmiao
You should use unc name like \\virtual_sql_name\share, or add r:\ as sql resource's dependency in cluster admin.
Brilliant!! Thanks a million! |
|
|
|
|
|
|
|
|
Drive Letter assignment in Active/Active