Forum Discussion

bret_miller's avatar
bret_miller
Level 4
11 years ago

Restore SQL Server 2000 Database to SQL Server 2008

In 2005, I backed up a SQL Server 2000 database with a prior version of Backup Exec. Since then SQL Server was upgraded to 2005, then to 2008, and Backup Exec was upgraded to 2012 with several interi...
2012
Agent for Microsoft SQL Server
Backup and Recovery
Backup Exec
Restore
Windows Server (2003-2008)
  • pkh's avatar
    pkh
    11 years ago

    You can duplicate the tape backup onto disk so you do not need another tape drive.  The media server requirements for BE 2010 is not very much.  You can load both the SQL 2000 and BE on the same machine, restore whatever you want on this machine and then release the machine.

pkh's avatar
pkh
Moderator
11 years ago

I had seen a Symantec document which states that to restore a SQL database it must be restored the same version and patch version.  However, I cannot find that document at the moment.  This requirement makes sense in that when you apply a SP, it does upgrade the database.  I know this is no comfort to you, but you can confirm the restoration requirement with Microsoft.  BE calls the SQL API to do the backup and restores.  If the API refuses to do the restore, there is nothing much that BE can do.