Solved

SQL Maintenance Plan

Posted on 2016-11-28
3
30 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
  • 2
3 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 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 69

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now