Viewing 15 posts - 7,831 through 7,845 (of 9,244 total)
Windows 2008 now offers the ability to create multiple clustered DTC resources, you could have one for each instance or just use the one
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:55 am
keep the locked pages but you will need to review your MAX Memory settings!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:54 am
more importantly, SQL Server does not care whether the quorum is an MNS or a disk!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:48 am
rdecker (8/4/2010)
If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:32 am
WayneS (8/4/2010)
Perry Whittle (8/4/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 10:17 am
you're wlecome.
you would need to either move the group via cluster administrator or pull the public network connection on the active node for the service to fail over!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 9:12 am
Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 9:08 am
blue_inelush (8/3/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 5:24 am
Hi
also try to post in the correct forum. Posting a topic from which i can see has nothing to do with high availability in the HA section is not a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2010 at 3:10 pm
ALZDBA (7/31/2010)
Meaning if you would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2010 at 3:06 pm
the failover partner connection string parameter is only required if confuring automatic failover. You need to be using either the SQL native client or ADO.NET
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2010 at 11:36 am
Hi
shrinking or growing a database will affect the database file size and ultimately the location of portions of the file on disk (they won't always be contiguous).
The OS file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2010 at 3:34 am
Bhuvnesh (7/26/2010)
this is new to me. are you sure for it ?
Yes!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2010 at 3:29 am
Lowell pretty much has the take here, dynamic ports on sql server instances will give the issues you are seeing only upon instance restart though!
Depending on how you connect you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2010 at 3:18 am
Ashaaban
what edition is your SQL Server 2008?
i.e. standard, enterprise?
If you're using Standard edition the lock pages in memory option is ignored unless you have SQL Server patched to SP1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2010 at 2:50 am
Viewing 15 posts - 7,831 through 7,845 (of 9,244 total)