Restoring from 2000 backup to 2005 instance

[dcuffee]

I did a backup of a 2000 database using the 2005 management studio. I then created a blank database on my 2005 instance. 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?

[rmiao]

Restore it with restore statement, use replace and move options. You can find detailed syntax in books online.