• I would suggest that you create a new database on the same server. You then need to retrive info on the datbase you setup using sp_helpdb NewDatabase. This together with info from the original database can be used in the following query to restore the database into the new location.

    restore database DatabaseName from disk = 'G:\..\DatabaseBackup.BAK'

        with replace,

             move 'OrigDatabaseDataDeviceName' to 'G:\..\NewDatabaseDataDevice.MDF',

             move 'OrigDatabaseLogDeviceName' to 'F:\..\NewDatabaseLogDevice.LDF'

    Stephen Marais
    Integration Architect
    Digiata Technologies
    www.digiata.com