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.
maintenance-plan
101
questions
0
votes
0
answers
17
views
Time between constrained datatimes
I need to calculate the operating time between failures of a equipment, respecting its operating schedule.
Basically I have a corrective maintenance dataframe with the start and end time in the format ...
0
votes
0
answers
49
views
Way to ensure maintenance plan attempts every stored procedure?
I have a stored procedure that is run based on plant name.
I have a maintenance plan that calls the stored procedures for all plants in a timezone like
execute dbo.runPlantSP('plant1')
execute dbo....
0
votes
1
answer
79
views
SQL rebuild Index Maintenance Plan is missing the Index Stat Option to set fragmentation percentages?
My maintenance plan is missing the section in the config window that allows you to set the fragmentation > a percentage. Does anyone know how to get this option or is it maybe I'm on too old a ...
0
votes
1
answer
122
views
Getting a 503 for the resources as well while setting up for a maintenance page in NGINX
I'm trying to set up a maintenance page for an application, hosted via NGINX web server.
Currently I have this set up.
location ^~/maintenance/ {
root /path/to/the/maintenance/maintenance....
0
votes
1
answer
1k
views
Maintenance tasks on Azure SQL Managed instance
I have 4 SQL managed instances and have some custom task defined on SQL Managment Studio. On azure I found that the managed instance have a Maintenance Window:
My question is.. What kind of tasks are ...
0
votes
1
answer
141
views
How do I maintain zabbix for MongoDB backup? with ansible
I have to implement zabbix maintenance for Mongodb backup with ansible
the tasks are as follows:
https://www.zabbix.com/documentation/5.4/en/manual/maintenance
https://docs.ansible.com/ansible/latest/...
0
votes
1
answer
919
views
Azure Used Vs Allocted Vs Maximum in elastic pool
I'm currently doing some cleanup on an Azure environment and just wanted to check calculations. I have about 55 Databases on an elastic server, which is currently sitting at 3.64TB of the maximum 4TB. ...
0
votes
1
answer
221
views
SQL Server 2016 Maintenance Plan Editor - Add Annotation Not Working
I'm using: -
Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64)
SQL Server Management Studio 15.0.18384.0
I have created a brand new Maintenance Plan for a ...
0
votes
0
answers
251
views
calculating MTBF in Excel
I'm trying to Calculate MTFB with what I have, which isn't much, using Excel.
Date
Full Plate Number
Vehicle Type
Status
1/2/2021
1234 ABC
TRAILER
OUT OF SERVICE
1/3/2021
1234 ABC
TRAILER
OUT OF ...
0
votes
1
answer
181
views
Do re-indexing of database runs automatically with CRM app?
It's my first time using CRM as an app. I have been using SQL Server for quite a while now. Our company is experiencing issues with emails, thus having warnings in event viewer
Query execution time ...
6
votes
1
answer
3k
views
How to handle maintenance process with React
Here is my app’s current way to handle the maintenance process:
I have an environment variable for the app status:
REACT_APP_SITE_MODE=“LIVE” | “MAINTENANCE”
I'm using react-router for routing the ...
0
votes
1
answer
510
views
SQL Maintenance Plan - Determining Duration of Steps
I'm trying to keep a maintenance plan under 30 minutes. The duration of each step indicates this should be the case, but the plan is running over 1 hour.
The check database integrity ends at 20:04:16 ...
0
votes
0
answers
441
views
SQL server backup issue - locked file
We have standart maintenance BACKUP plan
Task of backup has verifyonly option enabled.
During perfroming of backup we have failed job because VERIFYONLY task failed because of backup file was holded ...
0
votes
1
answer
389
views
SQL maintenance job failing: "Invalid object name 'Confluence.sys.Partitions'. Changed database context to 'master'
My database is called "Confluence". The maintenance job has always failed since that job was setup 6 months ago. Attempting to run the job manually also fails with same error.
Executed as user: NT ...
0
votes
0
answers
486
views
SSISDB Size growing too much
I had set the RETENTION_WINDOW property to 5 and OPERATION_CLEANUP_ENABLED to true and SSIS maintenance job is running every day at night but SSIDB still growing too much now it is more than 110GB ...