June 11, 2004 at 8:41 am
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??
June 11, 2004 at 9:18 am
RESTORE DATABASE <NEWDBNAME>
FROM DISK = ' <FILENAME> '
WITH MOVE ' <DATAFILEFROMSYSFILES> ' TO ' <NEWDATADISKFILENAME> ',
MOVE ' <LOGFILEFROMSYSFILES> ' TO ' <NEWLOGDISKFILENAME> '
June 11, 2004 at 9:27 am
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?
June 11, 2004 at 9:33 am
Right click on databases, select restore.
In the box type in the new database name, hit the options tab and change the RestoreAs filenames.
June 11, 2004 at 9:37 am
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 ???
June 11, 2004 at 10:54 am
Indeed, it matters not.
June 11, 2004 at 10:56 am
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