Submitted by Anonymous (not verified) on
Symptom

Unable to perform data entry due to insufficient space.
 
            Error number: 9002
            Message: SQLSTATE = 37000
           [Microsoft][ODBC SQL Server Driver][SQL Server] The transaction log for database                     
            ‘database-name’ is full due to ‘LOG_BACKUP’.
          
           No changes were made to database.
 
           INSERT INTO [table name is typically listed here followed by the column headings]

Cause

The database log file size causes insufficient disk space on the server and negates the ability for any data (cards) to be added/inserted into the SQL tables.

Resolution

At the FR50 Server:

Stop the SQL Server Service

  • Navigate to the file location on the server where the database files reside

  •            Example:  C:\Programs Files\Microsoft SQL Server\MSSQL11.Instancename\MSSQL\Data

  • Right click over the database log file, and select re-name. 

  •            Example:  FR50DB_Log.LDF, re-name to XXFR50_log.LDF

  • Re-start the SQL Server Service

  • Login to Database – a new log file will be created.

 
If the new log file does not create and returns the same error:
The transaction log for database ‘database-name ’is full due to ‘LOG_BACKUP’

Follow these steps:

  1. Login to SQL Server Management Studio

  2. Expand the Databases

  3. Right Click on the FR50 database, select Tasks > Detach

  4. Click OK in the Detach Database window

  5. Navigate to the database files location: C:\Programs Files\Microsoft SQL Server\MSSQL.11Instancename\MSSQL\Data

  6. Cut the FR50 log file and move it to a drive or external hard drive that has sufficient space


Warning: If you attempt to delete the log file – it may be too large for the Recycle bin, and the only option is to permanently delete it.

Use the following Script inside Management Studio to attach a SQL database (.mdf) file with a missing log file (.ldf): 


sp_attach_single_file_db @dbname= 'DB_name', @physname= 'C:\Program Files\Microsoft SQL Server\MSSQL11.InstanceName\MSSQL\DATA\DB_name.mdf'

Modify the above script by replacing the following values within the single quotes:

·         DB_Name with your database name
·         InstanceName with your instance name of SQL
·         The physical path of where your DATA files are located

A new log file will be created. 

Article Type
Product Info
Product Line
Fundraising 50
Product Module/Feature
Data Management
Ranking
No votes yet