Posted by Leisses Loud on 09/11/07 14:56

On 20 ago, 18:42, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Leisses Loud (leis...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
I need to remake the process but with some different issues. Now I am
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.

[Back to original message]