Is it possible in SS2K5 to restore from a backup between databases with
different MDF/LDF file locations? I don't have the option to recreate the
original directory structure on the target.
PaulCheck Books Online for the MOVE option to RESTORE DATABASE command.
"PJ6" <noone@.nowhere.net> wrote in message
news:ujFvDp1BIHA.536@.TK2MSFTNGP06.phx.gbl...
> Is it possible in SS2K5 to restore from a backup between databases with
> different MDF/LDF file locations? I don't have the option to recreate the
> original directory structure on the target.
> Paul
>|||Never mind, I got it. I finally found an example of RESTORE with MOVE and
discovered that the original file names must be specified without a path or
extention.
Paul
"PJ6" <noone@.nowhere.net> wrote in message
news:ujFvDp1BIHA.536@.TK2MSFTNGP06.phx.gbl...
> Is it possible in SS2K5 to restore from a backup between databases with
> different MDF/LDF file locations? I don't have the option to recreate the
> original directory structure on the target.
> Paul
>
没有评论:
发表评论