?
Solved

SQL Maintenance Plan

Posted on 2016-11-28
3
Medium Priority
?
67 Views
Last Modified: 2016-11-28
Have a database that had some authentication issues this weekend and caused transaction log to fill up, currently not a maintenance plan on this 2008R2 SQL server, was going to setup but was wondering should i shrink the database first to clear the logs or will maintenance plan do that on first full backup?
0
Comment
Question by:leadtheway
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 41904590
You should not clear the logs before backup, they should be cleared when backing up. If you don't care about your logs, change your recovery model to simple.
0
 
LVL 1

Author Comment

by:leadtheway
ID: 41904682
Should i do a different task for each DB or just put them together on same job?
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 41904684
it is your choice. If the job combining them all together does not take too long, I usually bundle them all in a single job
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question