Solved

Maintenance Plan history SQL Server 2008

Posted on 2015-01-12
3
66 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 46

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
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…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

20 Experts available now in Live!

Get 1:1 Help Now