Solved

Maintenance Plan history SQL Server 2008

Posted on 2015-01-12
3
68 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 49

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 25

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:Scott Pletcher
Scott Pletcher 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Union 2 queries to a cte (temp table perhaps) 9 49
GeoClustering  and AOG 25 43
how to make geography query faster?  SQL 7 45
Database Owner 3 21
In this article I will describe the Detach & Attach 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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