Announcement

Collapse
No announcement yet.

The transaction log for database is full due to LOG_BACKUP in MS SQL Server 2012

Collapse

Ads on showthread pages

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • The transaction log for database is full due to LOG_BACKUP in MS SQL Server 2012

    WordPress Hosting on SSD Servers

    Problem Statement

    The transaction log for database is full due to LOG_BACKUP.

    Solution

    You can truncate the transaction log file size using below SQL command sequence in SQL 2012.
    1. Login in database server.
    2. Select the database
    3. Click on new query
    4. Execute following SQL commands (replace the 'databasename' with your database name at all places in below commands.

      ALTER DATABASE [databasename] SET RECOVERY SIMPLE
      GO
      DBCC SHRINKFILE ([databasename_Log], 5)
      GO
      ALTER DATABASE [databasename] SET RECOVERY FULL
      GO
    Last edited by Marc_AccuWebHosting; 06-09-2015, 03:05 AM.
Working...
X
Sign up for a News Letter Click here to sign up