SQL Server version upgrade

(0) Share

Report

Posted on by Rick McKeon

990

We are running SQL Server 2000. Does anyone know if there are issues if we jump straight to 2008, or should we just go to 2005 first and update to 2008 after a while...

*This post is locked for comments

All responses (2)

Answers (0)

Ryan Sakry 3,425 on at

Like (0)

Report

Re: SQL Server version upgrade

Rick,

There is no reason not to start using 2008 from the get-go.

Matt,

That is actually the preferred way of doing the update.
Suggested answer

Community Member on at

Like (0)

Report

Re: SQL Server version upgrade

There is probably a better upgrade proceedure, but the way I did this was to export a .bck file through so manager, remove sql2000, install 2008 with same instance name (mssqlserver).

I used mixed mode so I can still use the sa password, but there is probably some security risk, then installed backward compatability from the feature pack, then restore the .bck file through the so manager again.