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:
-
Login to SQL Server Management Studio
-
Expand the Databases
-
Right Click on the FR50 database, select Tasks > Detach
-
Click OK in the Detach Database window
-
Navigate to the database files location: C:\Programs Files\Microsoft SQL Server\MSSQL.11Instancename\MSSQL\Data
-
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