| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-02-13 : 10:10:00
|
| Hi gurus,The data is automaticaly deleting from one perticular table at every night from last week onwords. I have created a delete trigger to find it out. But Nothing was recorded. There is no jobs except maintainance plans. Nothing in event viewer too. The database recovery model is simple. How can i solve this problemPlease advise me to solve this problemThanksKrishna. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-13 : 10:17:37
|
Is a transaction rolled back?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-13 : 10:18:35
|
| Create a profiler trace and see whats going on.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-13 : 10:18:52
|
| Is there any job running or Somebody is playing game.Please create trigger to track down. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-02-13 : 10:49:59
|
| Thanks for your reply, There is no rollback. There is no job. I have created the trigger already.but nothing was recorded.I am the only persion having DBA rights. My hairs are pulling out.-- Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-13 : 11:45:03
|
How many records are there in total for table?How many records are disappearing?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-02-13 : 11:49:37
|
| 1072 records on the table. all the records are disappering. The nextday morning the table will be an empty. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-13 : 12:28:31
|
| I guess its actually a truncate operation done by somebody. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-02-13 : 12:34:43
|
| let me try to find out thru Trace.Thanks for all your reply friends-- Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-14 : 01:53:34
|
Are someone dropping and recreating the table?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-02-14 : 12:09:59
|
| Dear all,Thanks for all of your valuble suggessions.Somebody has ran the Truncate command in midnight 2 00 AM. I found it thru trace. I found the user, but he is saying I am doing read only operation. So what I did is, i've just changed the security rights for the perticular user. Please suggest me if anyone have someother ways..Thanks once again to all-- Krishna |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-14 : 12:15:29
|
| Finally caught. As a DBA, should be really careful regarding Permission issues. Everything gets on DBA's head. |
|
|
|
|
Data from the table deleting automaticaly.