Results 1 to 2 of 2

Thread: Missing Data in databases

  1. 03-12-2002, 09:47 PM #1
    simon_shek Guest

    Missing Data in databases

    Dear all,

    I faced a problem. I found all data/records of tables in a few databases were missing yesterday. I don't know what had happened. Can anyone tell me why? Can anyone tell me how to trace the root of the problem. Any log files I can trace? I fear it will happen again. My server is sql2000 and run on win server 2000.

    Regards,
    Simon
    Reply With Quote Reply With Quote
  2. 03-13-2002, 10:47 AM #2
    Ray Miao Guest

    Missing Data in databases (reply)

    Check if there are triggers in the db. You can trace with profiler or use thirdparty tool, log explorer for instance, to view log.


    ------------
    simon_shek at 3/12/2002 9:47:58 PM

    Dear all,

    I faced a problem. I found all data/records of tables in a few databases were missing yesterday. I don't know what had happened. Can anyone tell me why? Can anyone tell me how to trace the root of the problem. Any log files I can trace? I fear it will happen again. My server is sql2000 and run on win server 2000.

    Regards,
    Simon
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules