Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring
Message
De
09/12/2011 09:21:19
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
Restoring
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01530727
Message ID:
01530727
Vues:
87
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform