Change Logical File Name during Restore Database

When I attempt to restore a SQL Server 2000 database
SAPProd backup to SAPConv, it works fine.
However, if I change the "Logical File Name" from
SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
I get an error message saying
"Logical file SAPConv_Data is not part of database
SAPConv ... ".
I just wonder is it possible for me to change the logical
file name during restore database. Besides, I would like
to know when will we use the Logical File Name.
Thanks
You can't change the logical file name when you do the restore, though you
can change the physical file name. That said, once you have restored the
database, you can use ALTER DATABASE to change the logical file name. You
use the logical file name for various ALTER DATABASE commands as well as
DBCC SHRINKFILE.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:20aee01c45981$75d62c00$a501280a@.phx.gbl...
When I attempt to restore a SQL Server 2000 database
SAPProd backup to SAPConv, it works fine.
However, if I change the "Logical File Name" from
SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
I get an error message saying
"Logical file SAPConv_Data is not part of database
SAPConv ... ".
I just wonder is it possible for me to change the logical
file name during restore database. Besides, I would like
to know when will we use the Logical File Name.
Thanks
|||Thank you for your reply.
I would like to know is there any problem if 2 databases
carry the same "Logical File Name" ?
Thanks

>--Original Message--
>You can't change the logical file name when you do the
restore, though you
>can change the physical file name. That said, once you
have restored the
>database, you can use ALTER DATABASE to change the
logical file name. You
>use the logical file name for various ALTER DATABASE
commands as well as
>DBCC SHRINKFILE.
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>..
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:20aee01c45981$75d62c00$a501280a@.phx.gbl...
>When I attempt to restore a SQL Server 2000 database
>SAPProd backup to SAPConv, it works fine.
>However, if I change the "Logical File Name" from
>SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
>I get an error message saying
>"Logical file SAPConv_Data is not part of database
>SAPConv ... ".
>I just wonder is it possible for me to change the logical
>file name during restore database. Besides, I would like
>to know when will we use the Logical File Name.
>Thanks
>.
>
|||Hi,
No issues at all. You can have same logical name for 2 or more databases.
You can even have the same physical names for 2 database sprovided the
physical files are kept in different
folders
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:20bed01c45987$d431b160$a401280a@.phx.gbl...[vbcol=seagreen]
> Thank you for your reply.
> I would like to know is there any problem if 2 databases
> carry the same "Logical File Name" ?
> Thanks
> restore, though you
> have restored the
> logical file name. You
> commands as well as
> message

Change Logical File Name during Restore Database

When I attempt to restore a SQL Server 2000 database
SAPProd backup to SAPConv, it works fine.
However, if I change the "Logical File Name" from
SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
I get an error message saying
"Logical file SAPConv_Data is not part of database
SAPConv ... ".
I just wonder is it possible for me to change the logical
file name during restore database. Besides, I would like
to know when will we use the Logical File Name.
ThanksYou can't change the logical file name when you do the restore, though you
can change the physical file name. That said, once you have restored the
database, you can use ALTER DATABASE to change the logical file name. You
use the logical file name for various ALTER DATABASE commands as well as
DBCC SHRINKFILE.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:20aee01c45981$75d62c00$a501280a@.phx
.gbl...
When I attempt to restore a SQL Server 2000 database
SAPProd backup to SAPConv, it works fine.
However, if I change the "Logical File Name" from
SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
I get an error message saying
"Logical file SAPConv_Data is not part of database
SAPConv ... ".
I just wonder is it possible for me to change the logical
file name during restore database. Besides, I would like
to know when will we use the Logical File Name.
Thanks|||Thank you for your reply.
I would like to know is there any problem if 2 databases
carry the same "Logical File Name" ?
Thanks

>--Original Message--
>You can't change the logical file name when you do the
restore, though you
>can change the physical file name. That said, once you
have restored the
>database, you can use ALTER DATABASE to change the
logical file name. You
>use the logical file name for various ALTER DATABASE
commands as well as
>DBCC SHRINKFILE.
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>..
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
> news:20aee01c45981$75d62c00$a501280a@.phx
.gbl...
>When I attempt to restore a SQL Server 2000 database
>SAPProd backup to SAPConv, it works fine.
>However, if I change the "Logical File Name" from
>SAPProd_Data to SAPConv_Data & SAPProd_Log to SAPConv_Log,
>I get an error message saying
>"Logical file SAPConv_Data is not part of database
>SAPConv ... ".
>I just wonder is it possible for me to change the logical
>file name during restore database. Besides, I would like
>to know when will we use the Logical File Name.
>Thanks
>.
>|||Hi,
No issues at all. You can have same logical name for 2 or more databases.
You can even have the same physical names for 2 database sprovided the
physical files are kept in different
folders
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:20bed01c45987$d431b160$a401280a@.phx
.gbl...[vbcol=seagreen]
> Thank you for your reply.
> I would like to know is there any problem if 2 databases
> carry the same "Logical File Name" ?
> Thanks
>
> restore, though you
> have restored the
> logical file name. You
> commands as well as
> message