Upgrade SQL 2000 DB to SQL 2014

I see that I need to backup a SQL 2000 DB and restore it to SQL 2008.  Then backup the 2008 DB and restore it to 2014.

I installed SQL Server 2008 R2 express (SQLEXPR_x64_ENU.exe).

How do I open a 2008 interface so I can restore the DB?
Sheldon LivingstonConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You  need SQL Server 2008 to do that, not 2008 R2, because the metadata update procedures now have no code for 2000 anymore.
Correction: You should be able to restore the 2000 DB on 2008 R2 without issues.
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You need to make sure certain Service Packs are installed in your instances. http://www.itprotoday.com/microsoft-sql-server/sql-select-steps-migrate-sql-server-2000-sql-server-2014 ist detailing the process.
Sheldon LivingstonConsultantAuthor Commented:
How do you bring up the Interface?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Shaun VermaakTechnical SpecialistCommented:
I understand that you want to upgrade from MSSQL 2000 to MSSQL 2014 but did you run DMA to check if it is compatible?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
As interface you can use the SSMS of 2014, or the new one (2017), whatever you have. You might have issues connecting to the 2000 with those, but the 2008 (R2) should work fine here.
Note that Express usually does not activate network access, only local (using shared memory).
Sheldon LivingstonConsultantAuthor Commented:
Does anyone know how to open 2008 express so I can attempt to restore?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Express does not come with Management Studio, you need to download one if you haven't already one installed. See my prior comment.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you only want to restore the database then you can use sqlcmd. Open a command prompt and positioning yourself in the same folder where sqlcmd.exe is and then run the following (where necessary replace with the real names from your system):
C:\>SQLCMD -E -S Servername\Express -Q "RESTORE DATABASE DatabaseNameHere FROM DISK='d:\backup\databasename.bak'"

Open in new window

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.