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 |
|
|
|
|
|