Thank you for your response Mr. Denny, I forgot to mention i have dts packages on the sql server 2000 will thos remain working?
I also have log shipping. Will the upgrade affect log shipping?
i should have asked this question first. What should i watch out for when upgrading sql server 2000 to sql server 2005?
I have log shipping also witll that have problems?
well this is how my upgrade went on four sql servers:
1. First error I got was in the tools installation part. I chose to install the tools but i did not have the tools folder and the servers folder together.
2. Log shipping broke! I had to fix it by backing up the main database in the primary server then restoing it in a standby mode in the secondary server. then applying all new transaction logs created after the full backup.
3. The rest was a piece of cake.