Posted by Neil on 06/05/07 01:53

OK, I got it to work. Seems I was using MOVE to move the MDF and LDF to
those locations; but the MDF and LDF for the database that was being
overwritten were already at those locations. So I removed the MOVE commands,
and it worked fine. The final version was:

RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH RESTORE

Thanks!

Neil


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9945EC53F9A4BYazorman@127.0.0.1...
> 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

[Back to original message]