Posted by Neil on 06/04/07 23:50

OK, replaced the original command with:

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',
REPLACE

Got the same error message.



"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

• Next in forum: Re: Db Design for Matrix Lookup
• 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]