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 - 2006-02-10 : 09:44:52
|
| Tom writes "HiI'm working on a process by which copies of a 'set' of databases will be created. The source is always the same. However, the destination will be different. I've looked at DTS as a way to help me with this process. The copy database wizard doesn't quite do what I need it to do. It might but I've not found any tips or examples. Here's the process:1) user enters the name of the new 'set'. (my code will make sure the name they entered is unique).2) the process copies the 'set' databasesThe 'set' of databases will be prepended with a prefix so that they remain a 'set'. The source/destination sql server are the same machine.Is there an easier way to make a copy of a database?ThanksTom" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-10 : 11:42:15
|
| You could backup the database and restore with move.. |
 |
|
|
|
|
|
DTS or another method?