?
Solved

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

Posted on 2016-09-14
7
Medium Priority
?
453 Views
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.
0
Comment
Question by:McKnife
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 28

Expert Comment

by:Dan McFadden
ID: 41797966
That means that the transaction log associated with the database RDCms has reach its configured max limit.  You need to do a full backup of the database and/or increase the limits for the transaction log.

*** not trying to be sacastic ***

What has a max size of 2TB?  Can you post a screen cap of the file properties of the database?

Also, right click on the database in SSMS, select reports then click disk usage, post that too please.

Dan
0
 
LVL 56

Author Comment

by:McKnife
ID: 41798009
Hi.
There's your screenshot:
ScreenshotI saw that thread on Technet but it is not useful since the "solution" was not described, he just mounted the DB and it started working again.

Also: why would I need to do anything like full backups on that DB, this should not be needed, never heard of it and I have been administering Terminal servers for almost 15 years.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 28

Expert Comment

by:Dan McFadden
ID: 41798050
Can't say anything about TS, but when a db complains that a transaction log is full, its usually because there is something limiting its growth (config or available disk) and to clear it, you need to take a backup thru SSMS, this allows the transactions in the log to be permanently flushed and saved to the db file.

Dan
0
 
LVL 56

Author Comment

by:McKnife
ID: 41798074
"there is something limiting its growth (config or available disk)" - but there is no such limit configured, nor is the disk anywhere next to full. I don't know what to think, I mean, I can set that DB to autoshrink and such and back it up once but will this permanently help? What is the reason I would need to do it at all?

Imagine, that log is logging logons to our TS. Worldwide there will be millions of TS' that are being used much heavier than ours, but I never saw anyone having to deal with this.
0
 
LVL 56

Accepted Solution

by:
McKnife earned 0 total points
ID: 41798082
By the way, trying to back it up fails:
--
TITLE: Microsoft SQL Server Management Studio
------------------------------

Backup failed for Server '\\.\pipe\MICROSOFT##WID\tsql\query'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Failed to flush the commit table to disk in dbid 5 due to error 2601. Check the errorlog for more information. (Microsoft SQL Server, Error: 3999)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=3999&LinkId=20476
0
 
LVL 56

Author Closing Comment

by:McKnife
ID: 41829525
I am giving up on this as it seems the file was just corrupted and no logic behind this error.
I restored it from backup more than 2 weeks ago and it has grown over the size that windows was complaining about the last time but this time without problems.
Thanks for participating.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question