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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-12-01 : 10:59:58
|
| Guys -Can anyone tell me how to retrieve a DTS package accidentaly deleted from the server using my database back ups ? (is it even possible ?)---"There's no sexy way to carry a lunch bag." My boss |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-12-01 : 12:02:14
|
| Got it. Restored msdb to a date prior of the day I deleted the dts package, on sysdtspackages (table) copied the rows where name (dts package name) = the name of the package I deleted and copied that over with a insert statement to the current sysdtspackages table on the msdb db.---"There's no sexy way to carry a lunch bag." My boss |
 |
|
|
|
|
|
Accidentaly deleted a DTS