Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

Maintenance Plan history SQL Server 2008

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
jamesmetcalf74
Asked:
jamesmetcalf74
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Mohammed KhawajaManager - Infrastructure: Information TechnologyCommented:
Under Maintenance Plans, right click on the plan and click on View History.  You will see the history log.
0
 
Scott PletcherSenior DBACommented:
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

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now