SQL Server Performance Forum – Threads Archive
DB marked as suspectHi,
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
& there is enough space where this DB is located.
what can be the possible reasons of this & what can be the solutions?
I don’t know what the problem in your case can be, but this topic may be helpful: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5779 — Marek Grzenkowicz
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
.. 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.