Viewing 15 posts - 7,696 through 7,710 (of 9,253 total)
I always set it, but only really required if you intend to configure\use failback policies!
August 31, 2010 at 10:46 pm
Jeff Moden (8/29/2010)
"How does the engine on my car make it go?".
🙂 Lets not start discussing the 4 stroke engine here!
August 29, 2010 at 12:52 pm
gmamata7 (8/28/2010)
Here is the solution:Extract the SP1 files to a temporary folder and then install SP1 from there.
Thanks
Extract the SP1 files to a temporary folder on the C drive and...
August 29, 2010 at 12:48 pm
There's a whole host of reasons why, remember that Windows 2003 SP2 is the minimum supported OS to cluster SQL server 2008. If management are happy opting for minimum spec...
August 29, 2010 at 11:47 am
This should work for you
ON CAST(a.BAN as varchar(??)) = s.BAN
where ?? is the varchar length!
August 29, 2010 at 11:28 am
TRACEY-320982 (8/29/2010)
We...
August 29, 2010 at 11:23 am
costs for 3rd party backup software are not that excessive. I prefer the rigidity that SQLBackup offers rather than using native backup compression
August 27, 2010 at 4:20 pm
Andrew Fowler-367854 (8/26/2010)
Perry, even using .net your failover might not be seamless if you are using connection pooling. Atleast that has been my experience.
good point!
August 27, 2010 at 4:11 pm
Don't pause any nodes, install SP3 from the active node.
Incidentally what version are you upgrading from?
August 26, 2010 at 3:16 pm
Depends on what you are trying to achieve. Thinking about it a little more you could have a copy of the web on the mirror and make the website live...
August 26, 2010 at 2:56 pm
jody 26314 (8/26/2010)
OR do i need to have the webapp on a different server than LIV and MIR?
Yes!!
August 26, 2010 at 2:09 pm
To make automatic failover seamless you will need the "Failover Partner=" parameter in the connection string if it's supported. You need to be utilising either SQL native client or ado.net.
For...
August 26, 2010 at 2:00 pm
GilaMonster (8/26/2010)
Please note: 2 year old thread.
originally yes, but not now 😀
August 26, 2010 at 12:27 pm
For SQL Server 2008 the main hive is at the following location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names
If SSRS is installed there will be an RS key in here
If DE is installed there...
August 26, 2010 at 9:24 am
Viewing 15 posts - 7,696 through 7,710 (of 9,253 total)