Solved

upgrade sql server standard 8.00 to express

Posted on 2014-03-13
3
339 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
ID: 39927424
Don't think this is MySQL...
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 39927491
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
ID: 39927713
Thanks Paul,
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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