Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicating database
Message
From
30/07/2012 15:10:08
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01549533
Message ID:
01549536
Views:
59
Likes (1)
>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.

Restore from the first one into a new one.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform