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

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â?¦My advice is to do functionality or, preferably, load testing in a dev\test
environment. As well as create a detailed project plan. I have run into a
lot of issues with upgrades but the clients that did throrough testing made
the fixes a part of the project plan instead of a Monday morning fire fight.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"sacgar" <sacgar@.discussions.microsoft.com> wrote in message
news:8D9F1A4F-B591-4E8D-8F63-0ACF2D0ED91C@.microsoft.com...
> 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â?¦
>|||Please go through the below article as I have faced this issue , check if
applicable in your scenario...
Thanks
Ajay
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:26E92972-53B2-4063-8D68-24B72C69FB94@.microsoft.com...
> My advice is to do functionality or, preferably, load testing in a
> dev\test environment. As well as create a detailed project plan. I have
> run into a lot of issues with upgrades but the clients that did throrough
> testing made the fixes a part of the project plan instead of a Monday
> morning fire fight.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "sacgar" <sacgar@.discussions.microsoft.com> wrote in message
> news:8D9F1A4F-B591-4E8D-8F63-0ACF2D0ED91C@.microsoft.com...
>> 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.
>|||Sorry Missed this link earlier
Please go through this link for DB Move
http://support.microsoft.com/kb/314546/
Thanks
Ajay
"Ajay" <ajudba@.gmail.com> wrote in message
news:OsXeYk0ZIHA.4272@.TK2MSFTNGP05.phx.gbl...
> Please go through the below article as I have faced this issue , check if
> applicable in your scenario...
> Thanks
> Ajay
> "jason" <jason-r3move@.statisticsio.com> wrote in message
> news:26E92972-53B2-4063-8D68-24B72C69FB94@.microsoft.com...
>> My advice is to do functionality or, preferably, load testing in a
>> dev\test environment. As well as create a detailed project plan. I have
>> run into a lot of issues with upgrades but the clients that did throrough
>> testing made the fixes a part of the project plan instead of a Monday
>> morning fire fight.
>> --
>> Jason Massie
>> www: http://statisticsio.com
>> rss: http://feeds.feedburner.com/statisticsio
>>
>> "sacgar" <sacgar@.discussions.microsoft.com> wrote in message
>> news:8D9F1A4F-B591-4E8D-8F63-0ACF2D0ED91C@.microsoft.com...
>> 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.
>>
>