Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Licensing, Cloud and Web Services
  • Welcome to Bentley Communities
  • Bentley's Communities
  • Licensing, Cloud and Web Services
  • More
  • Cancel
Licensing, Cloud and Web Services
Licensing, Cloud and Web Services Wiki The SQL transaction logs are full
    • Sign in
    • Eastern Europe Continuity Plan
    • Guest Accounts - Review Access
    • +Web Services
    • +SES Activation
    • +CONNECTION Client
    • +CONNECT Advisor
    • +Federated Identity
    • -SELECTserver based Activation
      • Understanding the (Legacy) SELECTserver Workflow
      • +Deployed SELECTserver Application Usage TechNotes and FAQs
      • Activating Against SELECTserver OnLine (a Bentley hosted server)[TN]
      • Activating Applications Using SELECTserver Based Licensing as a non-SELECT User
      • Activating Non-Licensed Trial Mode Software
      • Activation of Client Side Products and Registry Basics
      • Client Check In and Out Instructions for XM and Higher [TN]
      • Importing a Checked Out License (XML file) for XM and Higher [TN]
      • Disconnected Mode [FAQ]
      • Generating a License Debug Log
      • +License Management Tool
      • Product Activation [FAQ]
      • Product Activation Modes of Behavior
      • Renewal Process for All Licensing
      • Server does not support this Activation Key
      • Troubleshooting Product Activation for XM and Higher
      • -SELECTserver TechNotes and FAQs
        • "An Error Has Occurred" when manually transmitting usage logs using a preconfigured URL
        • About SELECTserver
        • Connecting to the Bentley servers through Firewalls and Proxy Servers [FAQ]
        • Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'
        • Data Update Service Warning [TN]
        • Database Maintenance
        • Database Setup Tool Configuration and Explanation [FAQ]
        • Deployed SELECTserver Database and Internet Connectivity Insight [TN]
        • Deployed SELECTserver issue with new Bentley SSL certificate
        • Deployed SELECTserver Knowledge Requirements [TN]
        • Deployed SELECTserver Technical Requirements [TN]
        • Enabling Diagnostic Logging for SELECTserver
        • Error 1068: Cannot start the Bentley SELECTserver service
        • Error 417 : in SELECTserver and GateWay logs
        • Glossary Of Licensing Terms [FAQ]
        • Group Policy Administration (ADM) files
        • How do I keep usage reports current?
        • How do I set up or prevent license checkouts?
        • How to create a new website in IIS7
        • How to create a Virtual Directory in IIS7
        • How To Install a Gateways on Vista and Windows 7, Server 2008
        • How to Install the SELECTserver application
        • HTTP Error 404.13 "The request filtering module is configured to deny a request that exceeds the request content length" when importing response file
        • HTTP Error 500.21 - Internal Server Error on SELECTserver Administrative Site
        • Import xml File on Deployed Server
        • IP Address Hosted Server
        • License and SELECTserver Administration [FAQ]
        • +License Manager
        • License Tool Command Line Options
        • Manual Installation of SQL Express (2008 - 2012)
        • Moving (relocating) the SELECTserver application to a new server.
        • Moving Your SELECTserver Database
        • +Older SELECTserver Versions
        • Opening Administration Site
        • Restricting access to a deployed SELECTserver Administration Site. Configuration example (video).
        • Running the Data Update Service and restarting IIS in order to immediately update a deployed license
        • Security [FAQ]
        • SELECT Server 08 11 Series [CS]
        • +SELECTserver
        • SELECTserver 9 Known Issues
        • SELECTserver 9.xx.xx.xx Gateway Update Process [FAQ]
        • SELECTserver 9.xx.xx.xx Upgrade Information [FAQ]
        • SELECTserver Database Backup [TN]
        • +SELECTserver Gateway
        • SELECTserver Gateway error 1053
        • SELECTserver Gateway Explained
        • SELECTserver Gateway License Server Revoked License [TN]
        • SELECTserver Gateway Service Fails To Connect through Proxy Server [TN]
        • SELECTserver General [FAQ]
        • SELECTserver in a IPV6 Environment
        • SELECTserver Notifications
        • SELECTserver Online Technical Requirements [FAQ]
        • SelectServer V9 without connectivity and Bentley Passport
        • SELECTserver XM Database Backup [TN]
        • SQL Server 2005 Cachestore Flush Error
        • SQL Server Compatibility Mode - Internal Query Processor Error
        • The response file corresponding to the following logs is not processed.
        • The SQL transaction logs are full
        • Transmit Usage Logs - 0 Logs Found To Process [TN]
        • Trust Licensing Basics [FAQ]
        • Unlock the SQL Server SA Account
        • Usage Log Processing - ERROR with status code 15014
        • Using Active Directory Group Policy Objects to Configure Licensing for Users Centrally (video).
        • What options are available to allow the external (WAN) user to access a Locally Deployed SELECTserver?
        • What's New in the latest SELECTserver?
      • Where do I find my Activation Key?
      • Stopping SELECTserver Activation Key based Usage
    • +Pre-SELECTserver Based Activation
    • +Product-Specific Licensing
    • Understanding why you received a TL Invoice
    • Working from Home using Bentley Licensing
    • +Licensing Workflow
    • How to leave a Product Review
    • +Serviços ProjectWise 365
    • About Bentley Trust Licensing
    • How to delete Bentley account and all related data
    • Support for non-Bentley technologies utilized by Bentley products
    • Support for V8i SELECTseries 10 applications after December 31st, 2021
    • +Support Homepage - Localized

    The SQL transaction logs are full

       
      Applies To 
       
      Product(s): SELECTserver
      Version(s): 09.00.00.99
      Environment:  N/A
      Area:  Installation / Configuration
      Subarea:  SQL Management
      Original Author: Michael.Dougherty, Bentley Technical Support Group
       

     

     

     

     

     

     

     

    Error or Warning Message

    There is an error message in the SELECTserver log files that the SQL transaction logs are full.

    Explanation

    As time goes by, the disk space requirements for the SELECTserver database may fluctuate greatly. This is due to how SQL server functions and will require the database to be maintained. You can set SQL Server to automatically expand a database when it requires more space; and you can also set it to "shrink" so it can reclaim allocated but unused space. Sometimes it makes sense to enable autogrow and autoshrink events, and sometimes it doesn't.
    (See KB #315512 from Microsoft for information about enabling each of these options.)

    Shrinking
    Data Files (*.MDF / *.NDF)

    If you haven't enabled the auto-shrink setting, there may be times when your database has been cleared of significant amounts of data, and you'd like to reclaim the space on disk that the partially empty MDF file is taking up. To do this, you can use the DBCC SHRINKDATABASE command. See this MSDN entry for the technical documentation on the DBCC SHRINKDATABASE or DBCC SHRINKFILE commands:

    To shrink the SQL Transaction logs, first figure out the database recovery mode. To find out if you database recover mode is set to full, bulk-logging, or simple right click on database, properties, click on Options in the window, 2nd drop down is the mode.  Here is bit more info on DB recovery modes: http://msdn.microsoft.com/en-us/library/aa173531%28v=SQL.80%29.aspx

     

    If your database recovery mode is set to FULL or bulk-logging, use the SQL statement below. 

    The example script looks like this

     USE [master]

    GO

    ALTER
    DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT

    DBCC
    SHRINKFILE(TestDbLog, 1)

    ALTER
    DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT

    GO

    When you use the statement above you
    have to change some of the values to match your database for a test db. This is
    what it looks like with a database name of hdr_oma_2-15-11

    USE
    [SELECTserver]

    GO

    ALTER
    DATABASE [SELECTserver] SET RECOVERY SIMPLE WITH NO_WAIT

    DBCC
    SHRINKFILE(SELECTserver _Log, 1)

    ALTER
    DATABASE [SELECTserver] SET RECOVERY FULL WITH NO_WAIT

    GO

    In this case, SELECTserver is the name of the database as seen in sql management studio

    SELECTserver_Log is the logical name of the transaction log. You can find this by right clicking on the database and selecting properties, click on 'files' and look in the 'logical name' column.

    If your database recovery mode is set to Simple the script is a bit simpler, 

    USE
    [master]

    GO

    DBCC
    SHRINKFILE(TestDbLog, 1)

    GO

     

    So in my case

    USE
    [SELECTserver]

    GO

    DBCC
    SHRINKFILE(SELECTserver_Log, 1)

    GO

     

    See Also

    Increase SQL Server Performance for the SELECTServer

     

    Technical Requirements
    http://communities.bentley.com/products/licensing/w/Licensing__Wiki/selectserver-technical-requirements.aspx

    SELECTserver FAQ:
    http://communities.bentley.com/products/licensing/w/Licensing__Wiki/selectserver-general-faq.aspx

    Deployed SELECTserver Knowledge Requirements

    http://communities.bentley.com/products/licensing/w/licensing__wiki/deployed-selectserver-knowledge-requirements-tn.aspx

     

    REFERENCE

    http://blog.sqlauthority.com/2010/05/03/sql-server-shrinkfile-and-truncate-log-file-in-sql-server-2008/

    http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html

    • SQL Management
    • General information
    • Installation / Configuration
    • 09.00.00.99
    • SELECTserver
    • Share
    • History
    • More
    • Cancel
    • Michael Dougherty Created by Bentley Colleague Michael Dougherty
    • When: Mon, May 6 2013 11:59 AM
    • Tyler Q - Bentley Last revision by Tyler Q - Bentley
    • When: Mon, Jul 29 2013 3:36 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies