SQL Server Performance

DB marked as suspect

Discussion in 'General DBA Questions' started by Jack123, Oct 25, 2004.

  1. Jack123 New Member

    Hi,
    Can you plz help me in this ?
    I have successfully attached one DB but after we connect to it using our application s/w, after some time it is marked as suspect.

    I found the log file was too big, so i used the following command & it is shrunk :-
    BACKUP LOG database_name WITH TRUNCATE_ONLY
    DBCC SHRINKFILE(log_file,2)
    & there is enough space where this DB is located.
    what can be the possible reasons of this & what can be the solutions?
  2. chopeen Member

  3. chopeen Member

    quote:Originally posted by Jack123

    I have successfully attached one DB but after we connect to it using our application s/w, after some time it is marked as suspect.
    What does exactly after some time mean?

    Did you try adding an additional log file (sp_add_log_file_recover_suspect_db)?

    --

    Marek Grzenkowicz
  4. satya Moderator

    .. and also check event viewer and SQL error log for further information on this occurence.
    Place the data and log files in the drive and delete unwanted files for free space.
    If the Tlog backups are not important you can deploy SIMPLE recovery model.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page