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 |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2008-04-17 : 08:10:46
|
| HiI write a query Truncate table tablenameit was Not within transaction block then how i will rollback data. DataBase is in FULL recovery mode. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-17 : 08:13:21
|
1) restore from backup2) use Lumigent or similar log recorvery tool
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2008-04-17 : 08:20:30
|
| Is not any query for rollback ?Ranjeet Kumar Singh |
|
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2008-04-17 : 08:34:10
|
| PleaseRanjeet Kumar Singh |
|
|
|
|
|
|
Rollback Data