Viewing 15 posts - 7,696 through 7,710 (of 9,244 total)
Don't pause any nodes, install SP3 from the active node.
Incidentally what version are you upgrading from?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 2:00 pm
GilaMonster (8/26/2010)
Please note: 2 year old thread.
originally yes, but not now 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 9:24 am
IMHO replication can be even more of a royal PITA, clustering is fairly smooth as long as you know\understand the technology!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 8:44 am
not worried about the database, just need to enumerate the RS instance registry keys on the server where RS is installed, this will provide the info required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 6:06 am
parthi-1705 (8/25/2010)
It is just the situation that was given to me, it may be due to some more data might have up added additionally or due...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 3:45 am
Ya, wmi is good but you can get just about any info from the registry ( if you know which keys to find it in) and SQL Server provides a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 10:21 pm
That doesn't really work if the RS database is remote to the RS instance. It also makes assumptions regarding the naming context of the RS database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:31 pm
You're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:18 pm
Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:46 pm
Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:45 pm
You could use xp_regread and parse the RS instance name keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:36 pm
Viewing 15 posts - 7,696 through 7,710 (of 9,244 total)