Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Location
    Yangon,Myanmar
    Posts
    10

    Question Unanswered: If has any way to alternate way to solve Data base suspense problem, I would like...

    In may database has over 20000 transaction per day
    i have always a problem, data base suspense. How can i escape this problem. and How can i recover my lost data.


    With regard
    Last edited by kongaung; 01-01-09 at 01:23.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Probably inefficient code.
    You will need to examine the most common and most expensive statements being issued against the database.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    If u mean to say Database going to suspect state , Might be some DBCC jobs that runs every day or at some regular timings . Check it

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Full/Diff/Log backups are a necessity for any OLTP based system.

Posting Permissions

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