upgrade sql server standard 8.00 to express

Hi All,
We have to upgrade a sql server standard 8.00 (sp4) to express.
When I try to restore the sql 8 backup onto the latest express server it is unable to process the file (too old)
How does one overcome this?
Do I have to install an intermediate version of the SQL Server, and do it in 2 steps?
What versions should I use for the intermediate and final?
Can they both be installed on one box?

thank you
LVL 7
COACHMAN99Asked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
Yes direct upgrade from SQL Server 2000 (Version 8.0) to SQL Server 2012 is not supported you need to upgrade to SQL Server 2005/2008/2008r2 first.

Good blog here on all the ins and outs :

http://blogs.msdn.com/b/mspfe/archive/2012/12/06/sql-server-upgrade-advisor-considerations-when-upgrading-from-sql-2000-to-sql-2012.aspx
0
 
Dan CraciunIT ConsultantCommented:
Don't think this is MySQL...
0
 
COACHMAN99Author Commented:
Thanks Paul,
0
All Courses

From novice to tech pro — start learning today.