It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,845
×10,943
×6,024
×4,710
×81
×23

question asked: Apr 28 '14, 9:09 a.m.
question was seen: 4,832 times
last updated: May 05 '14, 9:37 a.m.

Related questions

Saving artifact causes “The transaction log for database "qmsuite" is full." message

0
Serdar Fener (18●6●6) | asked Apr 28 '14, 9:09 a.m.
edited May 05 '14, 9:37 a.m. by Krzysztof Kaźmierczyk (7.5k●4●80●103)
After we try to save any artifact on RQM we get the following error saying: "Error raised in CLMTEST environment saying “The transaction log for database "qmsuite" is full."

We have encountered the issue before and we have cleared the transaction logs from the database and we were able to save artefacts. But after a while we encountered the same issue again. How can we avoid the issue to happen after and after again?
Comments
Krzysztof Kaźmierczyk commented Apr 28 '14, 9:20 a.m.

Hi Serdar,
What is your database vendor/version you use?

Serdar Fener commented Apr 28 '14, 9:34 a.m.

Hi Krzysztof,

Vendor: Microsoft SQL St Edition

Version: 2008 R2

Server: Windows Server 2008 R2


Accepted answer

0
permanent link
Krzysztof Kaźmierczyk (7.5k●4●80●103) | answered Apr 28 '14, 10:08 a.m.
edited May 05 '14, 9:30 a.m.
Try changing row version system for the database. From the command line tool, run this command:

ALTER DATABASE qm SET READ_COMMITTED_SNAPSHOT ON GO

If it does not help, please use following technote to fix the issue: Troubleshoot a Full Transaction Log (SQL Server Error 9002)
Serdar Fener selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.