Is This Content Helpful?
We're glad to know this article was helpful.
If a connection attempt is made into an ArcSDE SQL Server database in which the transaction log is full, the following error occurs:
"Failed to connect to database. Operation Failed."
Upon further review of either the direct connect log file or the ArcSDE service log file, the following error can be seen:
"DBMS error code: 9002 The transaction log for database is full."
Every ArcSDE SQL Server database consists of two files, an .mdf file and .ldf file. The .mdf file is the primary data file and is the starting point of the database and points to the other files in the database. The .ldf is the log file which holds all of the log information used to recover the database. All database modifications are written to this log file prior to these modifications are implemented within the database, thus allowing the database to roll back or restore transactions in the event of either an application error or hardware failure.
When a transaction log file grows until the log file uses all the available disk space and cannot expand any more, data modification operations can no longer be performed on the database.
In order to address this issue, please consider the following:
The size of the SQL Server transaction log can be monitored using the following command, executed in a new query window:
This command can be used to monitor the amount of space used in a transaction log and provides transaction log space usage statistics for all databases, displaying the current size of the transaction log and the percentage of log space used for each database.
It is always recommended to take full backup of all your databases and consult your database Administrator before following the given suggestions.