Server: Msg 9002

[lcalabro]

Server: Msg 9002, Level 17, State 6, Procedure DelTDByTrxNum, Line 83
The log file for database 'agresso' is full. Back up the transaction log for
the database to free up some log space.

How do I check the archive log files sizes, how full they are, how to auto extend the log files? How can I fix the error above?

[JinxT]

Server: Msg 9002, Level 17, State 6, Procedure DelTDByTrxNum, Line 83
The log file for database 'agresso' is full. Back up the transaction log for
the database to free up some log space.

How do I check the archive log files sizes, how full they are, how to auto extend the log files? How can I fix the error above?

Hi,

If the data is not critical, consider changing to Simple Recovery Mode, if it is critical then you need to stay in Full recovery but implement frequent log backups.

ALTER DATABASE mydb SET RECOVERY FULL/SIMPLE
GO


here is a useful site: http://www.akadia.com/services/sqlsrv_programm ing.html

[ck9663]

Server: Msg 9002, Level 17, State 6, Procedure DelTDByTrxNum, Line 83
The log file for database 'agresso' is full. Back up the transaction log for
the database to free up some log space.

How do I check the archive log files sizes, how full they are, how to auto extend the log files? How can I fix the error above?

Start from here

-- CK

[siva538]

Hi,

If the data is not critical, consider changing to Simple Recovery Mode, if it is critical then you need to stay in Full recovery but implement frequent log backups.

ALTER DATABASE mydb SET RECOVERY FULL/SIMPLE
GO


here is a useful site: http://www.akadia.com/services/sqlsrv_programm ing.html

In the database properties, you can set the data/ tran file size to unlimited growth and set the growth to 10% or 20%, etc as per your requirement.

[siva538]

Forgot to mention one more point that when you try to shrink the file, you will be able to see the free space available and the space occupied etc