Don't pause any nodes, install SP3 from the active node.

Incidentally what version are you upgrading from?

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...

Yes!!

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...

originally yes, but not now 😀

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...

IMHO replication can be even more of a royal PITA, clustering is fairly smooth as long as you know\understand the technology!

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

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, 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...

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.

You're welcome 😉

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!

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!

You could use xp_regread and parse the RS instance name keys in the registry!