Posted by Erland Sommarskog on 06/04/07 21:12

Neil (nospam@nospam.net) writes:
> I'm trying to use ADO to restore a SQL 7 database using a backup file.
> The database already exists on the target computer, and is named the
> same as on the source computer, and the MDF and LDF files are named the
> same as well.
>
> I am running the below in a stored procedure:
>
> RESTORE DATABASE DB1
> FROM DISK = 'c:\mssql7\backup\DB1.bak'
> WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
> MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'
>
> And I get an error message "File 'DB1' is not a database file for database
> 'DB1' ".

Add ", REPLACE" to your command.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How to distinguish operation type in trigger?
• Prev in forum: Re: Copy Row Of Data From Table to Table In Same DB
• Thread view: Re: Restore Database Fails

[Reply to this message]