Hi,
I was trying to restore my database and received the error described
in image.
http://img404.imageshack.us/my.php?image=errorestorebibliose scdb3.jpg
I just search for a solution but didn't found yet.
If someone could help me I'd be grateful.
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=errorestorebibliose scdb3.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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
On 20 ago, 18:42, Erland Sommarskog
> 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=errorestorebiblios escdb3.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/down loads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/boo ks.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/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
On 11 set, 18:22, Erland Sommarskog
> 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/down loads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/boo ks.mspx
I made just it some hours after post here and found the problem. Thank
you for the answer.