Solved

Sharepoint 2010 maintenance plan

Posted on 2014-03-12
2
440 Views
Last Modified: 2014-03-14
Excuse my ignorance on this but are there built in SQL mainteance plans in Sharepoint 2010 that run maintenance plans from Sharepoint. My Sharepoint and SQL run on two different servers. There are no maintenance plans in SQL but is it possible something is running on Sharepoint that connects to SQL to run the plans remotely?
0
Comment
Question by:Sid_F
2 Comments
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points
ID: 39923693
In Central Admin you get Health Warnings, some of which relate to SQL such as log files being too large. It's possible to set these rules to Auto Fix. Doing this means that log files are shrunk automatically from SharePoint. There are several other rules where you can set such actions, I suggest you check that out.
0
 
LVL 5

Author Closing Comment

by:Sid_F
ID: 39928632
Thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

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

12 Experts available now in Live!

Get 1:1 Help Now