![]() |
Transaction Log is Full |
Post Reply ![]() |
Author | |
mfaypatterns ![]() Newbie ![]() Joined: 06-August-2010 Status: Offline Points: 3 |
![]() ![]() ![]() ![]() ![]() 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 ![]() Newbie ![]() Joined: 06-August-2010 Status: Offline Points: 3 |
![]() ![]() ![]() ![]() ![]() |
How can I delete old transactions?
|
|
![]() |
|
ProductCart ![]() Admin Group ![]() ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
![]() ![]() ![]() ![]() ![]() |
This error means that your SQL database transaction logs need to be purged... which is something the hosting provider can do very quickly.
|
|
![]() |
|
Hamish ![]() Admin Group ![]() Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
![]() ![]() ![]() ![]() ![]() |
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.
|
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |