First off, apologies if this is not the correct place for this post.
I have been having a problem with one of our databases on our SQL server 2005 edition and the problem seems to come back to the logs (transaction I think). They are getting too big and every now and then disables access to the database. I can get around this by detaching the database then re-attaching it but I want to cure the problem rather than have a work around. How do I set the SQL backup job to clear the logs after the backup has completed? Unfortunately I am not very good with SQL and am learning as I go so would like a step by step guide to do the changes.
Question
StrikedOut
Hi All.
First off, apologies if this is not the correct place for this post.
I have been having a problem with one of our databases on our SQL server 2005 edition and the problem seems to come back to the logs (transaction I think). They are getting too big and every now and then disables access to the database. I can get around this by detaching the database then re-attaching it but I want to cure the problem rather than have a work around. How do I set the SQL backup job to clear the logs after the backup has completed? Unfortunately I am not very good with SQL and am learning as I go so would like a step by step guide to do the changes.
Thanks in advance.
J.
Link to comment
Share on other sites
4 answers to this question
Recommended Posts