Hi All,
Sql server 7.0
i have a db ABC and want to restore it as ABCbak, I am
taking the backup of the db ABC and restoring it on
ABCbak, i am also seeing that the physical names are
different but logical names remains the same. Will this
cause any kind of problem to db ABC.
Waiting for reply.
TIA
AdilYou should be able to do this using the "with replace" phrasing to allow SQL
to overwrite the other database. You will probably also have to use "with
move" to ensure the physical files do not try to go to the same place as the
existing ones. The logical names staying the same is not a problem but can
be changed with ALTER DATABASE after the restore is complete if you so
desire. Check out BOL for the exact syntax.
Christian Smith
"haseeb" <anonymous@.discussions.microsoft.com> wrote in message
news:11cf901c3f647$cca656b0$a101280a@.phx.gbl...
> Hi All,
> Sql server 7.0
> i have a db ABC and want to restore it as ABCbak, I am
> taking the backup of the db ABC and restoring it on
> ABCbak, i am also seeing that the physical names are
> different but logical names remains the same. Will this
> cause any kind of problem to db ABC.
>
> Waiting for reply.
> TIA
> Adil
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment