MS SQL Transaction Logs full

MS SQL Transaction Logs full

MS SQL defaults to only truncating the transaction logs once the database and transaction log have been properly backed up. At that point the server will clean truncate and compact the log files. 

Obviously, this requires having a backup system in place to backup the SQL databases and trigger that truncation. 

If you don't have a backup system in place or it is not backing up, or not properly triggering the truncation process, you can backup/truncate the database by hand using the SQL Server Management Studio. 

Backup the Database: 

Backup the Transaction Log: 

Shrink the Database: 

If you run into issues with the transaction log still not truncate, you can use an SQL command to truncate it: 
BACKUP LOG <database_name> WITH TRUNCATE_ONLY; 

However, MS removed the TRUNCATE_ONLY parameter from Server 2008. In that case, you can use this statement that backs up the database to null, and triggers the truncation: 
BACKUP LOG <database_name> TO DISK='NUL:';

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Change Reset Password Button Text

        Change the text of the "Reset Password" button on the UW Login Page How to change the text of the Reset Password button on the Login Page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants ...
      • Remove Reset Password Button From Login Page

        Remove the Reset Password Button from the Login Page How to remove the Reset Password button from the Unified Workspace login page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants Expand ...
      • Lenovo Unified Workspace End-of-Life Questions and Answers

        As of January 31st 2024, Lenovo Unified Workspace (formerly Stoneware WebNetwork) is no longer supported. This means that we no longer provide licenses, downloads, updates, patches, or technical assistance for this product. If you have any questions ...
      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...
      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...
      • Related Articles

      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...
      • What does webNetwork send to the SQL server to purge logging data each night?

        Each night at midnight the loader sends a SQL command to the SQL server to purge old log information.  That command is as follows : DELETE FROM LogTable WHERE LogTime < 'some date'; 'some date' is formatted like this: yyyy-MM-dd HH:mm:ss If your ...
      • Full screen Web Client

        How do I get the Microsoft ActiveX RDP client to go full screen? Add the parameters FullScreen = True  **Requires the webapp's link to be set to open with "Native Window Override".
      • Move SQL Databases to a new SQL Server

        Issue Customer would like to move their UW SQL Databases from older hardware to new hardware. Solution The easiest method is to use the same SQL database type, as this only requires exporting/importing the existing database from the old server to the ...
      • Configuring MS SharePoint through webNetwork

        SharePoint will work through webNetwork, but there are a few issues.  SharePoint really is designed for a full MS environment, if you are not using IE, you may lose some functionality.  There are a few Microsoft URLs that should be referenced.  ...