none
How to import a SQL 2005 .bak file on SQL 2008

    Question

  • Hi Team,

    I am trying to import/restore a SQL 2005 .bak file onto SQL 2008 instance, but i am getting everytime the below error message:

    "Too many back up devices specified for backup ot restore; only 64 are allowed"
    RESTORE HEADERONLY is terminating abnormally"

    Could you please provide the correct way/route on restoring the .bak file onto SQL 2008 Instance.

    Thanks In Advance


    Wednesday, February 22, 2012 4:21 PM

Answers

  • Hi, you should be able to restore a .BAK file to any newer version of SQL Server.  Typically this error is hit when you try to restore to a lower version (ex: onto SQL Server 2000). 

    How are you trying to restore the DB?  From SSMS, you can right-click on the database node –> All Tasks –> Restore Database –> From Device –> Select Devices –> Add your .bak file. Click OK.  

    You may need to change the logical/physical file names if it was backed up from a different server.  To do this, click the Options tab. On the left side you should see the Logical file name of the database from the .bak file.  The right side label ‘Move to physical file name’ should be the path that the .bak file originally existed as. This field needs to be changed to the path & file name of the database you’re restoring to.  After modifying those two fields, check the ‘Force restore over existing database’ and click ‘OK’.

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Wednesday, February 22, 2012 4:52 PM
    Moderator