Solved

upgrade sql server standard 8.00 to express

Posted on 2014-03-13
3
335 Views
Last Modified: 2014-03-13
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
0
Comment
Question by:COACHMAN99
3 Comments
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
Don't think this is MySQL...
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
Comment Utility
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
 
LVL 7

Author Closing Comment

by:COACHMAN99
Comment Utility
Thanks Paul,
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Creating and Managing Databases with phpMyAdmin in cPanel.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now