restore a database to the same server with a different database name??

  • I am having to do some juggling (due to space problems) and they want a backup from January of a particular Database retored without overwriting the current database (same server)

    Can I create a new Database with the same logical filenames for the data and log files as the original database, different physical filenames for the data and log files and restore while keeping the original database intact??

  • RESTORE DATABASE <NEWDBNAME>

    FROM DISK  = ' <FILENAME> '

    WITH MOVE ' <DATAFILEFROMSYSFILES> ' TO ' <NEWDATADISKFILENAME> ',

    MOVE ' <LOGFILEFROMSYSFILES> ' TO ' <NEWLOGDISKFILENAME> '



    Shamless self promotion - read my blog http://sirsql.net

  • Can i do the same thing from Enterprise Manager by creating a new Database (different name) that has the same logical file names as the original but different physical disk filenames?

  • Right click on databases, select restore.

    In the box type in the new database name, hit the options tab and change the RestoreAs filenames.



    Shamless self promotion - read my blog http://sirsql.net

  • Thank you so much!!!! what I was concerned with MOST was having 2 databases with the SAME logical Filenames - but I guess it doesn't matter as long as the actual Database name and the PHYSICAL file names are different ???

  • Indeed, it matters not.



    Shamless self promotion - read my blog http://sirsql.net

  • Thank you again!!! It was a huge Database.. around 25gb !!!

    The restore took awhile, but it worked like a charm!!!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply