• This is a simple task if you use the RESTORE DATABASE T-SQL command.

    First, get the file info from the backup file:

    RESTORE FILELISTONLY

    FROM DISK='backup file path and name'

    Then, restore WITH MOVE:

    RESTORE DATABASE Your New DB Name HERE

    FROM DISK='backup file path and name'

    WITH MOVE 'logical file name from filelist' TO 'your new location for that file',

    MOVE 'logical file name from filelist' TO 'your new location for that file',

    STATS,

    REPLACE --if overwriting an existing DB

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden