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 |
|
gvd
Starting Member
21 Posts |
 Posted - 2006-07-18 : 13:47:08
|
| Hey people, any body who knows how to undo the last changes to a database through an update statement. ThankxI dont have a backup. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-18 : 14:00:16
|
| There is no update statement that can undo the changes. If your database is in full recovery model, then you might be able to use a third party tool such as Lumigent's Log Explorer to read the transaction log.Tara Kizer |
 |
|
|
gvd
Starting Member
21 Posts |
Posted - 2006-07-18 : 15:48:17
|
| Thank you very much for your advice. But I will like to know how to find out if my Database is in full recovery mode before acquiring the Lumigent's tool |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-18 : 17:57:04
|
| If this is 2000, then right click on your database, go to properties, then options tab.Tara Kizer |
|
|
|
|
|
|
Restore Changes To a DB