Hi,
I was trying to restore my database and received the error described
in image.
http://img404.imageshack.us/my.php?i...liosescdb3.jpg
I just search for a solution but didn't found yet.
If someone could help me I'd be grateful.

Leisses Loud (leisses (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On 20 ago, 18:42, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
having the following error message:
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'BIBLIOSESCTO_Data' is not part of database
'BIBLIOSESCTO'. Use RESTORE FILELISTONLY to list the logical file
names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Leisses Loud (leisses (AT) gmail (DOT) com) writes:
So run RESTORE FILELISTONLY as it says in the error message to find out
what the names of the logical files are.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On 11 set, 18:22, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
I made just it some hours after post here and found the problem. Thank
you for the answer.