troubleshooting Question

Remote Desktop Session host: connecting impossible due to "The transaction log for database 'RDCms' is full "

Avatar of McKnife
McKnifeFlag for Germany asked on
Windows Server 2012Databases
7 Comments1 Solution4381 ViewsLast Modified:
Hi experts.

Our terminalserver 2012 R2 stopped to accept new connections. Active connections remained active at the same time.
Nothing was changed but I found this in the application eventlog (event occurs at the same time the problem started):
Event ID 9002
"The transaction log for database 'RDCms' is full due to 'CHECKPOINT'."
Source: MSSQL$MICROSOFT##WID

What should that mean? The files that the WID uses are in C:\Windows\rdcbDb and are less than 200 MB of size. Connecting to \\.\pipe\MICROSOFT##WID\tsql\query in SLQ management studio 2012, I can verify that the maximum size is 2 TB, so why do 200 MB pose a problem?

I overcame the problem by exchanging these files in C:\Windows\rdcbDb against backup copies, (200 kb smaller) but the problem might return.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros