Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Sacramento, CA
    Posts
    28

    Unanswered: Restoring from 2000 backup to 2005 instance

    I did a backup of a SQL2000 database (named Winstis) using the 2005 management studio. I then created a blank database on my 2005 instance (named Winstis). I then tried to do a database restore to the new 2005 database. I got an error:

    System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Winstis' database. (Microsoft.SqlServer.Smo)

    I even tried the option to Overwrite Existing database and I got a different error:

    System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\test.ldf'. (Microsoft.SqlServer.Smo)

    Also the 2005 instance database is on C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Winstis_Data.mdf

    and the 2000 instance is on
    D:\Program Files\Microsoft SQL Server\MSSQL\Data\Winstis_Data.mdf

    How can I accomplish getting the database from 2000 to 2005 with all tables, store procedures, and functions?

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    you can restore from a 2000 backup to a 2005 server, but only if the db you are restoring to doesn't exist on the 2005 server at restore time.

    so delete the winstis db on your 2005 instance then restore from the bak, should work ok then.

  3. #3
    Join Date
    Sep 2003
    Location
    Sacramento, CA
    Posts
    28
    Hi Jezemine,
    I actually tried it that way as well. I finally got an answer from another forum. The key was using the move options on the RESTORE.

    Thanks though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •