Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an application build on SharePoint 2007 platform, and currently I encounter a common issue where the Database Log file growth rapidly and fill up the hard disk space.

In my situation, I wanted to remain the recovery model as FULL because in future might need for point-in-time recovery and database mirroring.

My question is, how can I perform an automated backup of transaction log regularly? please advice and this is open for any comment.

Thank you in advanced.


migration rejected from Oct 2 '13 at 23:38

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Paul White, RolandoMySQLDBA, bluefeet, Jon Seigel Oct 2 '13 at 23:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, RolandoMySQLDBA, bluefeet
If this question can be reworded to fit the rules in the help center, please edit the question.