Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: What does it mean???

    What a database has the word (Suspect) next to it, what does it mean?

    Example: IISLOG(Suspect)

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Lots of things; most of them unpleasant.

    1. SQL can't find one or more physical files for the database.
    2. SQL can find the data file and the log file, but they are not synchronized (the log file and the database file are from different moments in time).
    3. SQL ran out of disk space when trying to recover (restart) a database (error 1105, see BOL).
    4. Some other corruption has occurred in the database.

    If the error is caused by #3 above, see the BOL about recovering the database. Otherwise, you may find yourself restoring from a backup.

    Regards,

    hmscott

    Quote Originally Posted by milan1115
    What a database has the word (Suspect) next to it, what does it mean?

    Example: IISLOG(Suspect)
    Have you hugged your backup today?

  3. #3
    Join Date
    Jul 2004
    Posts
    191
    That's the problem there is no back up to back up from.

    I tried to detach the file but could not.

    The error I got was

    Could not allocate space for object 'iislog' in database 'IISLOG' because the 'DEFAULT' filegroup is full..

    I was trying to delete the records in this database that was already archive.

    another message is:

    The log for database 'IISLOG' is not available..

    I was able to archive at least 97% of the data, now I need the 3%.

    Is it possible for me to copy the data file to another server using terminal server?

    Thanks

    Lystra

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    I have only a limited amount of experience recovering suspect databases; mostly those that I have forced into suspect mode myself and I always had a backup to work from.

    It sounds to me as though you are out of disk space on the server; try eliminating other files from the server. Stop SQL Server; eliminate any and all unneeded files and then restart the server.

    Also, look at the BOL "suspect database" (Resetting Suspect database Status). That has some step-by-step instructions.

    Good luck.

    Regards,

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Jul 2004
    Posts
    191
    Now my once suspect database have disappear totally from EM.

    How do I get it back? Does anyone have any ideas?

    Thanks

    Lystra

Posting Permissions

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