SQL Server Performance

'AS IS' Upgrade from SQL 2K to SQL 2K5

Discussion in 'SQL Server 2005 General DBA Questions' started by sqlexpert, Feb 3, 2008.

  1. sqlexpert New Member

    Hi , We are planning for ‘in place’ SQL Upgrade from SQL 2000(Ent. Edition with SP4) to SQL 2005 Ent.Edition with SP2 for 1)Replication Distribution Server that serves to PULL subscriptions.2)One for the Subscriber Cluster (Active Passive)Server (its distribution server already upgraded to SQL 2005) We have gone through the requirements from Microsoft Technical Resource Guide but looking if somebody had any issues or any advice other than Upgrade Advisor reported before we move for Upgrade for both of above cases as some people indicated they had issue with Password Policy , Appreciate your reply…
  2. satya Moderator

    Before the upgrade it is better to stop replication and once it is on 2005 better to re-initiate the replication, also what kind of errors/warnings given by Upgrade Advisor?
  3. sqlexpert New Member

    for Replication Distribution server i am getting which i dont understand so any help is appreciated...
    Object reference not set to an instance of an object
    FTMULTIPLEINSTANCES

Share This Page