By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Server: Msg 9002

P: 1
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?
Mar 29 '08 #1
Share this Question
Share on Google+
4 Replies


P: 9
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_programming.html
Apr 17 '08 #2

ck9663
Expert 2.5K+
P: 2,878
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
Apr 17 '08 #3

P: 44
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_programming.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.
Apr 17 '08 #4

P: 44
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
Apr 17 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.