SQL Server Performance Forum – Threads Archive

DB marked as suspect

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?

---

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

---

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>