Posted by Erland Sommarskog on 06/05/07 20:42

Neil (nospam@nospam.net) writes:
> 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.


The the problem is that the logical names of the files are not DB1 and
DB1_log. You can retrieve these names with RESTORE FILELISTONLY.


--
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: SQLServer Table Partitioning
• Prev in forum: Re: ADODB Command (Stored Procedure)
• Thread view: Re: Restore Database Fails

[Reply to this message]