Posted by Jonathan Roberts on 02/20/07 17:07

blueboy wrote:
> Hi,
>
> I am planning to automate a nighty restore of a DB on another server
> can someone point me in the right direction with the SQL script to
> modify the logical file names to the correct path and not the ones
> carried over with the DB??
>
> i.e the database is to be renamed on the new server
>
> any help much appreciated
>
> Many thanks in advance
>

This should point you in the right direction:

http://support.microsoft.com/default.aspx?scid=kb;en-us;314546

If you restore the database to a different file location than the source
database, you must specify the WITH MOVE option. For example, on the
source server the database is in the D:\Mssql\Data folder. The
destination server does not have a D drive, and you want to restore the
database to the C:\Mssql\Data folder.

Good luck

[Back to original message]