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 |
|
timsmith
Starting Member
11 Posts |
 Posted - 2008-07-30 : 15:05:47
|
| Hi,Again a pretty basic question. I have a backup copy of an MS sql server 2005 database. Does the server 2005 keep a log of deleted records (when, which table etc.)? And if so, how can I get to them?thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 15:17:17
|
| What recovery model are you using? Do you perform transaction log backups? Are you willing to purchase a third-party product to read the transaction log?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
timsmith
Starting Member
11 Posts |
Posted - 2008-07-30 : 15:31:32
|
| I do not know yet what kind of backups were performed on the system. Any names/links to the software that could be useful?thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-07-30 : 19:53:30
|
| What about read it by yourself, of either using DBCC LOG ?I've some preliminary works regarding log files in MS SQL 2000.RgdsEka S.http://ekasiswanto.wordpress.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 20:10:40
|
| Good luck on that. There's a reason why vendors write tools like these. If it were easy to figure out, no one would purchase these tools, therefore vendors wouldn't write them.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 23:20:56
|
| >> Does the server 2005 keep a log of deleted records (when, which table etc.)?If db is in simple recovery model, you may unable to get those even with third party tools. |
|
|
|
|
|
|
Log of deleted records on SQL server 2005