Transaction Log is Full

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I keep getting this error:

Error: The transaction log for database '*dbNameHere*' is full. To find 
out why space in the log cannot be reused, see the log_reuse_wait_desc 
column in sys.databases

My customers cannot login to there account.  Any ideas?

(Edited by Hamish to remove the database name)

Edited by Hamish - 20-August-2013 at 2:26pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mfaypatterns Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 06-August-2010 Status: Offline Points: 3	Post Options Post Reply Quote mfaypatterns Report Post Thanks(0) Quote Reply Topic: Transaction Log is Full Posted: 20-August-2013 at 12:14pm
	I keep getting this error: Error: The transaction log for database 'dbNameHere' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases My customers cannot login to there account. Any ideas? (Edited by Hamish to remove the database name) Edited by Hamish - 20-August-2013 at 2:26pm

mfaypatterns Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 06-August-2010 Status: Offline Points: 3	Post Options Post Reply Quote mfaypatterns Report Post Thanks(0) Quote Reply Posted: 20-August-2013 at 12:15pm
	How can I delete old transactions?

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 20-August-2013 at 12:40pm
	This error means that your SQL database transaction logs need to be purged... which is something the hosting provider can do very quickly.
	The ProductCart Team Home of ProductCart shopping cart software

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 20-August-2013 at 2:29pm
	I think it's also worth taking a look at : http://support.microsoft.com/kb/317375 and investigating the cause to see if it is anything to worry about or not.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code