Stack Overflow
Stack Overflow

Questions tagged [maintenance-plan]

A Maintenance plan is any variety of scheduled maintenance to an object or item of equipment. In SQL Server a maintenance plan creates a workflow of the tasks required to make sure that the database is optimized, regularly backed up and free of inconsistencies.

105 questions
2
votes
2 answers

Sql Server Maintenance Plan Tasks & Completion

I have a maintenance plan that looks like this... Client 1 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next Client Client 2 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next…
Bennett Dill
  • 2,875
  • 4
  • 41
  • 39
2
votes
0 answers

MSSQL Backup Immediately Suspended [BULKOP_BACKUP_DB]

Our production database server has stopped running the backup maintance plans... The server has plenty of space, upon googling and futher investigation it appears the backups are being halted they moment they are started. Running "Select * from…
UltimateVenom
  • 45
  • 1
  • 7
2
votes
1 answer

MS SQL 2005: 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 see that what happened (I know it seems crazy)…
Johannes Wentu
  • 931
  • 1
  • 14
  • 28
1
vote
1 answer

Is it possible to edit a SQL Server maintenance T-SQL query without creating a new one?

Need to edit a maintenance plan backup cleanup job. It can't find any place to edit the job through a Query editor. How can this be done without disabling the job and creating your own job? tia.
Mang G11
  • 219
  • 5
  • 12
1
vote
2 answers

Backup SQL Server Maintenance Plan

Is it possible to backup Maintenance Plan? Is it enough to backup msdb database that has all Agent Jobs? I use SQL Server 2008. Thanks.
a1ex07
  • 36,826
  • 12
  • 90
  • 103
1
vote
0 answers

Backup maintentce plan stopped working. Error -1073548784

Maintenance backup plan worked for a while. But a few weeks ago it stopped. I've noted it when I've run out of free space on a drive. So it creates a backup files, but stopped deleting outdated. At first, I thought it was a permissions issue - but…
AlexanderK
  • 365
  • 7
  • 21
1
vote
0 answers

SQL Server 2016 - Maintenance Plan to delete differential backups linked to old full backup

We have two maintenance plans which takes care of differential and full backup. The differential backup runs everyday and deletes backups older than 1 week. The full backup runs every Sunday and deletes any full backup older than 1 week. I am…
Chiranjib Sarma
  • 13
  • 3
1
vote
0 answers

run .sql file automatically by maintenance plan

I have an ordinary SQL Query (insert ... / update...) I run from daily manually in SQL Management Studio. In some cases the query Need to be improved. However I want to execute the SQL Statement in maintenance plan to avoid Manual work. This works…
Volker
  • 447
  • 1
  • 5
  • 19
1
vote
1 answer

Do I need a maintenance plan to prevent a known SQL Server timeout from happening in the future?

We have a query in our C# / LINQ to EF code which consistently caused a timeout when run through our web application (ASP.NET MVC). Error message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the…
Winks
  • 580
  • 1
  • 7
  • 17
1
vote
0 answers

Does SSD drive make indexes rebuild and update stats useless with SQL Server?

Now that SSD is a standard de-facto. Can the maintenance job of rebuilding indexes and updating statistics, using Ola Hallengren https://ola.hallengren.com/ jobs for instance, be done only on demand instead of regularly such as on weekly basis with…
Alex P
  • 11
  • 2
1
vote
0 answers

Maintenance Plan read Server Agent log

I am new in maintenance plan and server agent. I have created two server agent job named as ABC and with type T-SQL (SELECT * FROM ABCDEFG), and server agent job named as DEF and with type T-SQL (SELECT * FROM ABC). When I execute ABC job in server…
Arzozeus
  • 103
  • 2
  • 11
1
vote
1 answer

SQL Server - no maintenance plan task name in Logs

I have weird bug in SSMS logs - after creating and running an maintenance plan it seems there is no subtask/plan names in Logs as shown below. Any advice what went wrong?
Damian_L
  • 85
  • 4
1
vote
1 answer

Unable to save SQL Server maintenance plan

We have a maintenance plan for backing up databases and I need to change the destination filepath. When I open the plan in SSMS and make the changes then hit save, I get a message that says You are about to save maintenance plan "mtpblah" in a …
Sarah
  • 13
  • 4
1
vote
0 answers

Database Maintenance Plan Update Statistics Error

I get an error last night ,I get the following error message: Executing the query "UPDATE STATISTICS [dbo].[tables] W..." failed with the following error: "The multi-part identifier "tables.Id" could not be bound.". Possible failure reasons:…
shaghayegh
  • 23
  • 6
1
vote
1 answer

Which databases are used within a SQL maintenance plan?

I am adding an alert when a user logs into an application, if the Microsoft SQL database maintenance plan failed, did not run, was not implemented OR was never scheduled. I would prefer not to add a setting to identify the maintenance plans which…
Moon
  • 1,141
  • 2
  • 11
  • 25
1 2
3
4 5 6 7