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
0
votes
1 answer

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 Service\SQLSERVERAGENT. Microsoft (R) SQL Server…
c c
  • 11
  • 3
0
votes
0 answers

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 from 20GB. So I want to know is it good to set up a…
HARSHIT RATHORE
  • 143
  • 2
  • 6
0
votes
0 answers

Create a Maintenance plan to update user account status

I am looking to create a maintenance plan in the SQL Server Management Studio. For this maintenance plan, I need to update user accounts to a status = 0 (deactivated) after checking if the user has left the company or not. I have already gone ahead…
Obaid Ameen
  • 29
  • 2
0
votes
1 answer

Some of database on my Maintenance Plan won't backup with an error "Operating System Error Code 3(The system cannot find the specified path)"

I have this job on maintenance plan of SQL Server 2014 SP3 which backup "All databases" to a shared file of another server, but one database failed due to an error shown on my screenshot below. Note that the rest are successful and they are just…
WhitePenny
  • 3
  • 4
0
votes
4 answers

Maintenance plan maintenance cleanup task running successfully, but not deleting files?

This has been driving me crazy. I have tried all suggestions and no go. This absolutely does not work. The files are all still there. The job runs successfully, but the files do not delete.
richard
  • 12,263
  • 23
  • 95
  • 151
0
votes
2 answers

Add T-SQL in maintenance plan in SQL Server

How can I set a T-SQL statement as a part of a maintenance plan in SQL Server? Since I can see options of backup etc but not the possibility of adding T-SQL
Sebastian
  • 4,625
  • 17
  • 76
  • 145
0
votes
2 answers

Email Daily Maintenance Plan Report

Im currently running a Maintenance Plan on SQL that do the following: 1 daily full backup Hourly transaction log backup 1 daily maintenance cleanup On the reporting options I have it set up to send a report to an email recipient, so now Im getting…
alejandrobog
  • 2,091
  • 14
  • 20
0
votes
1 answer

What is best practice to use shrink SQL Server?

I have read a lot that shrinking database is not recommended practice as it causes a fragmentation that leads to slower performance. ref :…
Alfin E. R.
  • 741
  • 1
  • 7
  • 24
0
votes
0 answers

Is it necesary to shrink database then rebuild indexes and shrink database again and al this everyday?

I have entered in a new company as a DBA. I have seen they have a maintenance SP that do these steps: 1-Shrink database (this is bad!!) 2- check the indexes and rebuild those that have high fragmentation (this is good) 3- Create a script for those…
DavidLinares
  • 21
  • 1
  • 7
0
votes
0 answers

SQL Server Logs consistently get filled

I have issues with transaction logs on SQL Server 2012. I set up a job that does an automatic cleanup of logs, I used the following the plans below. Job name: Cleanup DB Logs Step 1: Do transaction log backup using Management wizard & go to "Step…
Smartiot
  • 1
  • 1
0
votes
0 answers

Schedule/Edit Maintenance Tasks for SQL Express (No Maintenance Plan Wizard)

I am using SQL Server 11.0.6251 Express (SQL Server 2012 Express). I have some software that logs data to the database continuously. However, there are some maintenance tasks that are performed on the database every so often. Whenever this happens,…
Fili G
  • 1
0
votes
1 answer

Maintenance plan - Failed to acquire connection "Local Server Connection"

My maintenance plans broke all of a sudden, after a Windows update. My backup routines cannot get access to the server any longer. I have tried with different user accounts, changing the connections in the "Manage Connection" window, in the…
André Snede
  • 9,899
  • 7
  • 43
  • 67
0
votes
0 answers

SQL Server 2008 R2 maintenance plan fails but no error message

I have a SQL Server 2008 R2 instance that I've been managing for many years. I have a daily backup maintenance plan that has 4 steps: Backup the databases (3 databases) Backup the transaction logs (3 databases) Delete backup files older than n…
andyabel
  • 335
  • 4
  • 15
0
votes
1 answer

Remote Maintenance Plans in SQL Server 2008

I've set up a maintenance plan in instance #1 of SQL Server 2008. In theory, it will connect to instance #2 and back up those databases to the hard drive of instance #1. I have: Created a login on instance #2 Given that login the correct…
divided
  • 1,249
  • 5
  • 14
  • 27
0
votes
0 answers

Transaction log backup has grown huge growth during index reorganize

I have a maintenance plan that does a full backup and a 'check database integrity' every night. I backup transaction logs every 15 minutes. The transaction log backup size spikes during index reorganize - exponentially bigger. I used to reorganize…
shaghayegh
  • 23
  • 6
1 2 3 4 5
6
7