Post reply

Help - I have an old backup of a SQL 7 DB that I need to restore

  • March 24, 2006 at 8:19 am

    #111498

    Unfortunately, I do not have a SQL 7 instance anymore and we now run 2000. I found this old backup and I need to get some information off of it but seem to haev issues when I try to restore to a SQL 2000 instance. Anyone have any recommendations?

    Thanks.

  • March 24, 2006 at 8:29 am

    #628644

    We've performed upgrades in the past from 7 to 2000 by restoring the databases and never had issues with this.  During the restore, SQL Server will recognize that it's a 7 version database and upgrade the structures to 2000 automatically.

    What specific problems are you having with your restore?  I suspect that you may be attempting to restore the database on a server that does not have the same disk or file structure of the original.  You can use the 'RESTORE FILELIST ONLY' command to view the original paths to the files.  Or you can create an empty database with the same name on your new server, then perform a restore from Enterprise manager with the 'Force Restore Over Existing Database' option checked.  Hope this helps. 

    My hovercraft is full of eels.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply