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 |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-05-22 : 09:41:25
|
| one of my tables had data in it and yesterday the data just disappreared. someone might have deleted from table by mistake.i need to look into the log file. what is the best way to look into it. i try to copy it to another location first but it tells me that log file is in use with another program but its not.Ashley Rhodes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-22 : 09:52:17
|
| You need third party tools like Lumigent's Log Explorer. |
 |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-05-22 : 10:04:59
|
| is that the only way out. Can i open it with a notepad or something else.Ashley Rhodes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-22 : 10:24:10
|
| No you can't. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-22 : 11:47:58
|
| Restore a backup to a Temporary database, and copy-back the table to your Live database?Kristen |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-05-22 : 15:19:54
|
| Kristen, I did that but i wanted to look into the log file and see how the table got deleted.Ashley Rhodes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-22 : 15:21:47
|
| Purchase a third party tool then.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
how to view log file