You must Sign In to post a response.
  • Category: SQL Server

    Records are being deleted from Live database

    Hi,

    From last few days our subscribers has reported some issue related to records missing in Live database.

    Now again we have the same problem with bunch of users. We have already scanned the delete queries in all the store procedures. Also, we had some doubts that id might be due to a back end application which runs daily. But now we come to know many of the affected users are not using this service.

    Can someone suggest how to identify the cause?

    FYI, the records are missing from reference table not from main table.

    Regards
    Vivek Sharma
  • #764986
    This is issue is completely depend on your application. To identify the issue you have to share more information about your table and logic. So that we can identify your issue. The information which you posted is not sufficient for us to identify the issue.

    Are you handling log. first step should be see the log and identify the issue. Or write more logs on related places and you can identify the issue clearly.

    By Nathan
    Direction is important than speed

  • #764995
    Without knowing your code it is highly impossible to trace out the error, one way is to use SQL profiler to know which queries are fired on database
    https://msdn.microsoft.com/en-in/library/ff650699.aspx
    Or I got a link to find user who ran DROP or DELETE statements on your SQL Server Objects, you make check it here
    https://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/
    OR you may set DELETE trigger on said table

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #765011
    Hi Vivek,

    Check with your DataBase admin, ask him to check the Logs, you can easily trace who delete that and at what time deleted everything using Logs,

    If you want to know the action, on what basis records gets deleted then you need to check your project full code.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


Sign In to post your comments