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 - 2005-09-27 : 07:53:54
|
| Matt writes "Assuming a PHB decided to try and copy the production database to another machine using DTS and accidentally wrote the wrong way, essentially clearing out all of the data in the production server, is there a way to roll that back other than restoring from backup?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-27 : 07:54:57
|
| Well, you could have PHB retype all the data, but since he/she screwed up the DTS part it's unlikely they'd get that right. So restoring a backup is your best bet, and uninstalling Enterprise Manager from their desktop would be a good idea too. |
 |
|
|
gaos
Starting Member
6 Posts |
Posted - 2005-09-27 : 18:07:15
|
| When using DTS copy databases, it de-attach the databases first, then copy. If something is wrong when copy database objects, then the task fails and the databases are not attached back again. So you need to attach the databases with original data files, and it is much faster than restore databases from backups. |
|
|
|
|
|
|
Rolling Back a DTS Copy