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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2005-11-29 : 15:46:32
|
| We did a dts package to copy a few tables from Database A to Database B. We choose the objects option in the dts wizard. Although we only picked two tables it brough over everything and overwrote our data. We did not notice the error until today because of low database usage.My question is can I apply all transaction logs from two backups ago skipping the 1 hour we did our dts package? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-11-29 : 17:00:51
|
| You will need the full backup, and an uninterrupted string of transaction logs. If you restore to the point in time just before the running of the DTS package, your options are to recover the database there and then, or to restore the next transaction log. Individual transactions can not be selectively restored. |
 |
|
|
|
|
|
Need Immediate Help (over wrote data)