Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duplicating database
Message
De
30/07/2012 14:08:43
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01549533
Message ID:
01549534
Vues:
69
The database name is stored a part of the database properties, so you'll need to attach the first one, rename it, then attach the second.

>Hi,
>
>By duplicate (in the title) I mean: take one of my databases and add the same database to the SQL server under a different name. I am think of doing the following:
>1. Detach the "original" database
>2. Copy two database files to some different name
>3. Attach both databases
>Will this work? Or what is a better way of accomplishing my task? TIA.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform