SQL Server transaction log problem

10 pts.
Tags:
SQL Server
SQL Server logs
An error like" Transaction log full.. backup thelog and shrink the database .. " occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was disabled by using DBCC command.. Still the error is repeating.. Kindly give solution int his regard.. The DBCC command used is DBCC shrink (dabasename,file size) where the file size given is 1.....

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you backing up the log or backing up the database? There is a difference.

If you need the ability to restore the database to a point in time you should schedule transaction log backups to occure through out the day.

If you do not need the ability to restore the database to a point in time you should change the recovery mode from full to simple. This will stop SQL Server from keeping the transactions in the log for more than a minute or two. You will not be able to backup the transaction log, therefor you can not restore to a point in time, however you shouldn’t get this error any more. If you do very large operations you may still run into this problem.

If you have set a max growth size for the log file you should remove this setting as well. Also make sure that the disk is not full.

What command did you use to disable the transaction log? There is no command which disables the transaction log.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following