Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring
Message
From
09/12/2011 09:21:19
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Restoring
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01530727
Message ID:
01530727
Views:
90
Hi,

I have two databases:

"DB" is the live data

"DB Test" is the test database

For testing I am backing up "DB" then restoring it into DB Test, selecting "Overwrite the existing database (WITH REPLACE)".

I am a bit concerned when I check the "Restore as" column, it refers to DB.dmf and ldf. Should I manually change these to "DB Test.mdf" and "DB Test.ldf"? I don't want my live database to be overwritten by this restore.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Next
Reply
Map
View

Click here to load this message in the networking platform