SQL 2005 in place

(imported topic written by jpeppers91)

Has any one done an in place upgrade from SQL 2000 to SQL 2005? If so, what are any gotchas or anything to look out for?

(imported comment written by SystemAdmin)

I would like for a customer with experience doing this to post also but I have done this with our customers many times without problems without problems. Just click the installers.

I would make a database backup and store it off beforehand.

(imported comment written by BenKus)

I did this upgrade on my deployment and it was fast and easy… Although I am always scared to upgrade SQL Server or MSDE because in older versions of SQL Server, it seemed to not work well…


(imported comment written by jpeppers91)

Are there any Bigfix services to stop or pre-maintenance that needs to be done before running the upgrade other than DB backups?

(imported comment written by SystemAdmin)

It wouldn’t be a bad Idea to stop all the BES Server services (FillDB and GatherDB make database connections). You might want to kick all the BES Console users off too before upgrading SQL. I have a feeling it will break the connections for you during the upgrade too though.

(imported comment written by SystemAdmin)

I remembered something that is a good idea to do after the sql upgrade! Your database will work fine after the upgrade but changing the compatibility mode helps it some.


(imported comment written by jpeppers91)