|
|
Posted by Neil on 06/05/07 01:17
As a followup to my previous message, I also tried the modified command
directly from Query Analyzer, and got the same message. I then tried to
restore the backup file from Enterprise Manager, and it worked fine. But
couldn't get the SQL to work.
However, I still need to get it to work, as I have an associate who needs to
restore the same backup set, but he doesn't have QA or EM. He's running the
SQL in a stored procedure using ADO.
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
Navigation:
[Reply to this message]
|