June 5, 2006 at 8:02 am
I keep getting the following error message every time i try to use the bossdata database. I have looked in the documantation and also in the log_reuse_wait_desc column in sys.databases but am at a total loss as to what i need to do to resolve this
[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'BossData' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Help
June 5, 2006 at 10:19 am
you need to backup the transaction log
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 5, 2006 at 10:21 am
Your transaction log for the BossData database is most likely full. You need to truncate the transaction log and then do a full backup of the database.
Check you disk drives also, as the drive holding the transaction log may also be be full. If it is, you will need to shrink your transaction log also.
If your BossData database is using full transaction logging, and you are only doing full database backups, your transaction log is not being truncated. This only occurs when you complete a transaction log backup.
Hope this helps.
Lynn
June 6, 2006 at 9:48 am
The error specifies that the transaction log for BossData is full.
I've found the best means for fixing this problem is.
1. Set the DB in to simple recovery mode.
2.Do a full Backup of the DB.
3. run this command
DBCC SHRINKFILE (LOGFILENAME, SIZEYOUWOULDLIKETOSHRINKTOinMB)
4. Do another full Backup of the DB.
5. Set the recovery mode back to previous setting.
To keep from experiencing the same problem again, either keep the db recovery mode set to simple, or do transaction log backups at a smaller interval.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply