1

I have SQL Server 2000 database backups with me. And I need to restore them to SQL Server 2012.

Can you tell me the best approach to do it?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Champ
  • 690
  • 1
  • 7
  • 13
  • 1
    There is no direct way to do this - SQL Server 2012 does **NO LONGER** support SQL Server 2000 backups. You need an intermediate step - restore your SQL Server 2000 databases to SQL Server 2008 / 2008 R2, then take new backups, and restore those to SQL Server 2012 – marc_s Dec 22 '15 at 06:46

2 Answers2

0

It is not supported. First you need to restore the db to sql 2005 or sql 2008 then take backup and restore it to sql 2012.

shine
  • 90
  • 1
  • 4
  • 13
0

You should've done some research before starting a new thread on SO, the reason for me to say this is that this question has already been asked on SO in a different context, but the solution has been clearly explained. Follow the answer that has been given at this link (Restore a SQL Server 2000 backup on SQL Server 2012)

Hope that this helps!

Community
  • 1
  • 1
N00b Pr0grammer
  • 4,503
  • 5
  • 32
  • 46