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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Service pack3a Installation

Author  Topic 

vdavid70
Yak Posting Veteran

67 Posts

Posted - 2005-06-25 : 04:47:25
Hi All,

I am trying to install sql server service pack3a on one of our Crm servers. The set up is in such a way that the Crm server has its own sql server 2000 installed on it and connects to another sql server 2000 instance which is actually a failover cluster setup.

Now my question is that is there anything i need to concider regarding the cluster before i apply the service pack on the crm application server.

regards,
victord

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-06-25 : 12:12:17
you've upgraded a test system that has this same configuration right?

Since there is no uninstall for a service pack, you should be prepared to have to completely reinstall SQL Server in case the wheels fall off. This means having the media available and the installation keys etc.

Also, when doing the upgrade make sure that your applicaiton cannot connect to the database. Any app that uses a user that has DBO privelege can interfere with the insallation of a service pack.



-ec
Go to Top of Page
   

- Advertisement -