Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: Database is suspect

    We have an SQL Server 2000 DB server with several databases on it. Frequently, one of the DBs will have a state of "Suspect." This appears to occur after our 3rd party backup software runs a full backup on the weekends.


    How can I begin to troubleshoot the cause of this issue? Has anyone seen anything like this?

    thanks,

    Jeff

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's in the error logs?

    Also, try Query Profiler and set up a trace before the backup occurs...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Unless your 3rd party backup tool is SQLLiteSpeed, in which case I don't think it's the reason, - disable any 3rd party backups and use the native. Also examine carefully your disks and make sure you're not running out of disk space on the drives where you place the backup devices. Try to move those devices onto a different drive other than the ones where your data and log devices live.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    How are you currently reviving the database ? Also, do you run dbcc checkdb on this database ? If you database is clean, no disk errors and you have plenty of disk space - contact this vendor to see if there are any known issues. Also, have big is this database and do you use any text/ntext... datatypes ?

  5. #5
    Join Date
    Jan 2004
    Posts
    6

    give the mdf to me.I will help you

    if you want pay some money

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Can you post the contents on your SQL server log as an attachment ... that might help.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

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