0
votes
1answer
28 views

Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times

SQL Server 2005: I have a problem with scheduling a Maintenance Plan (MP) with 3 subplans (SP). SP1 is scheduled to run hourly, SP2 daily at 7.00 and SP3 on sundays at 8.00 Reading MP history I ...
2
votes
2answers
724 views

Reindex job failing due to being victim of a deadlock, but it is the only process running at 3am..?

I have a reindex job in a maintenance plan which I run on every table in a given database at 3am so it won't interrupt any other work. However it is failing and reporting the reason as being the ...
2
votes
2answers
186 views

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored ...
0
votes
2answers
145 views

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding ...
2
votes
1answer
163 views

Sql server backups best practices. Too many files created?

I know this has been asked before, but I'm trying to understand this better. I traditionally used Backup exec to backup sql servers, but I now have two sql servers that are off-site and of course I ...
0
votes
1answer
296 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
0
votes
1answer
2k views

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
1
vote
4answers
319 views

SQL Server 2005 - Logs not being deleted

I have a SQL Maintance Plan that is set to backup my transaction log. I have it set to expire the transaction log after 2 days. The transaction log get created fine, but the old ones never get ...