Questions tagged [maintenance-plans]

Workflows created through SQL Server Management Studio that help automate SQL Server maintenance tasks like backups, index rebuilds, and updating statistics.

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
3k views

SQL Maintenance Plan 'Could not find part of the path' - where is it getting the path from?

I have a SQL Server 2012 maintenance plan which backs up all of the databases. Today I had an issue with a failed backup which I was able to resolve by viewing the detail in the 'Log File Viewer' ...
2
votes
0answers
74 views

In SQL Server 2014 Is it normal for for maintenance job to pick up a table that does not exist in database

As above, we are hitting an error on the maintenance plan running on SQL Server 2014. During update statistics when we got the error. "Msg 2706, Level 16, State 6 , Line 1" Table Flow Detail does ...
2
votes
0answers
35 views

SQL Server 2012 - Is There a Log That Captures DB Maintenance Type Activity?

I had a backup maintenance job setup for all system databases. I also have another job that sends me an email whenever a job fails. After receiving notification of the system database backup job ...
2
votes
1answer
415 views

Include stored procedure text output in the maintenance plan log

I have a maintenance plan subtask in SQL Server 2012 Enterprise that executes a stored procedure (or a SQL Server agent job). In the log file for this maintenance plan, there are a few lines for this ...
2
votes
0answers
490 views

Proxy Account SSIS and NETWORK SERVICE

I currently have an instance of SQL running as NETWORK SERVICE which for various reasons I can't change. I have a maintenance plan running under a proxy account which has access to a network share to ...
2
votes
0answers
240 views

Change version number of maintenance plan package

We have a Maintenance Plan on SQL 2012 that has been running fine. I made a change to it yesterday using SSMS 2014. When the plan ran last night I got the following error: The version number in the ...
1
vote
0answers
29 views

How to select specific databases in a backup retention policy maintenance plan cleanup task?

I have full backups of three different databases. Right now all of their backups follow the same retention policy, but I need to setup the retention to a different amount of time for each database. ...
1
vote
0answers
31 views

Maintenance Plan Failing After Database Collation Change

We currently use maintenance plans to perform index rebuilds each night (we inherited this system). Yesterday, i amended to the database collation to match the instance level collation (...
1
vote
0answers
905 views

Maintenance Plan job failing with access denied for NT SERVICE\SQLSERVERAGENT

I used the Maintenance Plan Wizard under SQL Server 2014 to create a simple maintenance plan that once a week: Check Database Integrity including indexes Rebuild Indexes Clean Up History When the ...
1
vote
1answer
149 views

Automatic database restore fails as cannot find file

A while back I asked for help automating a database restore using a backup file provided from another server: Automatically restore SQL Server database from file from another server. I'm pleased to ...
1
vote
0answers
106 views

Storing Configuration for bespoke maintenance plans

I got fed up with creating maintenance plans on several SQL servers. So I've devised a script that generate a series of SQL Agent Jobs (with notifications) that utilises Ola Hallengren's SQL Server ...
0
votes
0answers
38 views

Cannot modify a job in SQL 2008 R2. The Modify window simply doesn't come up

I created a maintenance plan to perform daily backups with transaction log backups to be scheduled on four hour increments, however, I did not enable the job immediately, nor did I enter add the ...
0
votes
0answers
48 views

Reporting & Logging Failing on SQL Server Job

System Info: SQL Server 2014 Enterprise, Windows Server 2012 R2, running on a VM I have a Maintenance Plan set up to perform a log backup of a database every 17 minutes. The job normally runs fine ...
0
votes
0answers
32 views

Maintenance Tasks causes CPU to peg 100% utilization

I do not believe the maintenance tasks themselves to be the primary issue here, however CheckDB and index rebuilds cause the server to become unresponsive w/ 100% cpu utilization. It is on one ...
0
votes
1answer
58 views

Unable to create maintenance plan

When trying to create a maintenance plan locally on two prod servers through SSMS, I receive this error: No such error occurs on my UAT system. They're all running SQL Server 2017 (14.0.3162.1), and ...
0
votes
0answers
45 views

CheckDB Failure on most databases in Dev instance

I have a maintenance plan on one of our infrequently used dev boxes which keeps failing on CheckDB on all user databases and most system databases. When trying to run CheckDB manually, I get the ...
0
votes
1answer
27 views

Maintenance Plan Wizard generates invalid date parameter in script for delete

The generated SQL for my Maintenance Plan is EXECUTE master.dbo.xp_delete_file 0,N'''',N'''',N''2019-01-02T10:44:21'' but the execution returns error message Msg 102, Level 15, State 1, Line 1 ...
0
votes
0answers
453 views

Reorganize index maintenance job is more than 20 times slower

I have a reorganize maintenance job which runs daily (I know, this have been altered to weekly) which for the majority of executions it takes around 2 hours however over the weekend has failed with ...
0
votes
1answer
49 views

How can I share values in maintenance plan tasks?

A simple example would be a maintenance plan that clears a directory of old files and create some copy backups of all databases on that instance to that same directory. This is run daily The first ...
0
votes
1answer
60 views

How can I automate the process of checking of column and executing SQL statement?

I am experiencing quite difficult problem and hope for your feedback. In my table I have a "Services"column in "MyData" table which contains names of my services. I have created SQL statement which ...
0
votes
1answer
203 views

Text file report is not generating of Availability Databases other Databases during auto backup through maintenance plans in MS SQL Server 2012

I have setup Automated backup in SQL Server 2012 Enterprise Database backup through 'Maintenance Plan'. I have also configure AlwaysOn High Availability to that server .There is 5 databases in the ...
0
votes
0answers
283 views

Can maintenance plans be used in SQL Server multiserver (Master-Target servers) administration?

Since I failed to configure SQL Server 2012 Multiserver (Master and Target Servers) administration, I am eager to understand whether it (setting Master and Target servers) would permit to send from ...
0
votes
2answers
547 views

Maximum Error Count Reached

I created a maintenance plan to backup all the databases locally on a folder in E Drive. Out of nowhere, the job is failing occasionally. sometimes the job runs successfully and sometimes sends an ...