Posted by Erland Sommarskog on 08/20/07 21:42

Leisses Loud (leisses@gmail.com) writes:
> I was trying to restore my database and received the error described
> in image.
> http://img404.imageshack.us/my.php?image=errorestorebibliosescdb3.jpg
> I just search for a solution but didn't found yet.
> If someone could help me I'd be grateful.

It looks as if you want to restore the database on a different machine.
And where there is no C:\Program Files, but well a C:\Arquivos de programas.

I would expect this command to work:

RESTORE DATABASE informa FROM DISK = '...'
WITH MOVE 'INFORMA_Data' TO 'C:\Arquivos de programas\...',
MOVE 'INFORMA_Log' TO 'C:\Arquivos de programas\...',
REPLACE

The ... represents the backup name and the location of the file that I was
too lazy to copy.


--
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]