Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicating database
Message
From
30/07/2012 14:08:43
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01549533
Message ID:
01549534
Views:
67
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform