Solved

Maintenance Plan history SQL Server 2008

Posted on 2015-01-12
3
65 Views
Last Modified: 2015-01-20
I have 4 maintenance plans for sql server 2008.   2 of them are backup jobs which I can obviously tell if they ran to see if I have back up files.  but the other 2 are for tasks like shrinking log files or reindexing db's.

where can I tell if they ran?
0
Comment
Question by:jamesmetcalf74
3 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 167 total points
ID: 40544458
Right-click on job name and check the job history. You can also verify it in the SQL Server logs or Windows Event Log.
0
 
LVL 24

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 167 total points
ID: 40544469
Under Maintenance Plans, right click on the plan and click on View History.  You will see the history log.
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 166 total points
ID: 40544765
You should not be routinely "shrinking log files".  You need to review those logs, get them properly sized, and leave them alone!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

10 Experts available now in Live!

Get 1:1 Help Now