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?i...liosescdb3.jpg
> > I just search for a solution but didn't found yet.
> > If someone could 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.

Leisses Loud (leisses@gmail.com) writes:
> 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.

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@sommarskog.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...@sommarskog.se> wrote:
> Leisses Loud (leis...@gmail.com) writes:
> > 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.
>
> 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, 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 made just it some hours after post here and found the problem. Thank
you for the answer.