logical file name

After backing up a database I restored it to a different database. The
physical file names are different but the logical file name is the same for
the two databases. Does this pose any problems?IMO, it shouldn't cause any problem.
--
Thanks
Yogish|||That is common and is not a problem.
--
Andrew J. Kelly SQL MVP
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:u2PVrWb%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> After backing up a database I restored it to a different database. The
> physical file names are different but the logical file name is the same
> for
> the two databases. Does this pose any problems?
>|||As the others have stated, this won't cause any problems. If you are using
SQL 2000 and want to be tidy, you can change the logical file name with
ALTER DATABASE. For example:
ALTER DATABASE MyDatabase
MODIFY FILE(NAME='OldDatabase', NEWNAME='MyDatabase')
ALTER DATABASE MyDatabase
MODIFY FILE(NAME='OldDatabase_Log', NEWNAME='MyDatabase_Log')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:u2PVrWb%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> After backing up a database I restored it to a different database. The
> physical file names are different but the logical file name is the same
> for
> the two databases. Does this pose any problems?
>