Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:20:54
|
| Norman writes "How can a complete database be duplicated?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-16 : 10:12:24
|
| A. Perform a full database backup and restore it in a new databaseB. Use Data Transformation Services (DTS) to create a package using the Copy Objects task or Transfer Database taskIf you need more help, you can look up these items in Books Online, it gives full descriptions of how to use them. Or you can post more details about your exact situation and we can take it from there. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-17 : 00:34:44
|
| Or copy the mdf/ldf files, and use sp_attach_db.-Chad |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-17 : 04:11:09
|
| Or replication or log shipping. It depends what you want the duplicate for, disaster recovery or as a test environment.HTHJasper Smith |
|
|
|
|
|
|
Duplicate SQL Server Database