We help IT Professionals succeed at work.
Get Started

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

McKnife
McKnife asked
on
4,356 Views
2 Endorsements
Last Modified: 2016-10-05
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.
Comment
Watch Question
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE