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

CRM Job Maintenance Logs in SQL Database

We are managing our CRM 2013 (on-premise) maintenance jobs via the "CRM 2011 Job Editor" (downloadable from Codeplex here: https://crmjobeditor.codeplex.com/). We have set a reindexing job to run daily, however we would like to double-check if the…
ichachan
  • 637
  • 1
  • 10
  • 34
0
votes
2 answers

SQL Server Maintenance Plan Cleanup Task

I am using a SQL-Server 2012 (SP2) on a WinServer 2012 R2. I created a maintenance plan that makes a backup of my databases and deletes report files and backup files that are older than 2 days. My problem is that the maintenance plan doesn't delete…
Murat Yazi
  • 85
  • 1
  • 8
0
votes
0 answers

POST from SQL Server Maintenance Plan with cURL

I'm looking to monitor various events that may occur within a SQL Server Maintenance Plan. My desired method for doing this is to have the maintenance plan do an HTTP POST with the data. After some research I think my preferred approach is to use…
Jason Cruickshank
  • 13
  • 3
0
votes
1 answer

T-sql to find backup folder for specific maintenance plan

I have to check multiple servers daily to find their backup folders (and maybe other data, like backup time, databases and backuptype). Is there anyway to write a script to list the backup folder if I know the name of the Maintenance Plan? I found…
Stiegler
  • 719
  • 6
  • 8
0
votes
0 answers

After Triggers in sql server

I have created two triggers. One on sysssispackages and another on sysjobs. thse two triggers will simply send a mail whenever anyone modifies a maintenance plan or a job(sans job schedule). My problem is whenever someone modifies a MP, i get…
priyan
  • 1
0
votes
1 answer

SQL Server slow index after time

One index of one my databases has the strange behaviour of getting slower after time goes by. Even though my maintenance plan includes a 'Rebuild index' step on all user databases. After a while it gets so slow that my entire application/server…
Erik
  • 417
  • 4
  • 14
0
votes
0 answers

tasks to be performed in a database maintenance plan in certain amount of time

In a database maintenance plan we have different tasks available to us to help us optimize the performance of our databases like these: Shrinking a database Backing up a database Performing an operator notification Updating database…
David Mendienta
  • 395
  • 2
  • 5
  • 11
0
votes
1 answer

Microsoft.SqlServer.Management.Smo.Server.Jobs.Job.EnumHistory() is limited to 100 rows

I am trying to write a script to scan for Sql Maintenance Task failures - see script below. I appear to be unable to process more than 100 entries using EnumHistory(). Does anyone have a way around this? Param( [int]$days="30" # this hardly…
David Rogers
  • 4,010
  • 3
  • 29
  • 28
0
votes
2 answers

Conditional maintenance plan for backups

I've set 2 schedules on a maintenance plan (SQL Server) for backups. One of the schedules is set to run each 1 hour for a full database backup, and the other is set to run each 20 minutes for a differential backup. The problem is that they will…
WoLfulus
  • 1,948
  • 1
  • 14
  • 21
0
votes
2 answers

SQL Server: Database Maintenance Plan

I have a small database for a school project and I need to create a Database Maintenance Plan with the following requirements: it has to manually (through scripting and not user interface) it must reorganize data and indexes it must validate…
chiapa
  • 4,362
  • 11
  • 66
  • 106
0
votes
1 answer

SQL Server 2008 R2 Maintenance Plan Logging

Does anyone know what table contains information that stores the folder that Maintenance Plan Reporting and Logging uses? I've searched every table in the MSDB that is named even remotely like it might contain it and so far I've come up empty. …
PseudoToad
  • 1,504
  • 1
  • 16
  • 34
0
votes
1 answer

Strange SQL Server Behavior

What I am trying to do is execute the stored procedure below automatically via a Maintenance Plan using the Execute T-SQL Statement Task. What I am seeing is that when this procedure runs as part of a maintenance plan, for some reason, the records…
Tehrab
  • 57
  • 1
  • 4
0
votes
1 answer

Is it possible to create backup jobs on SQL Server 2008 R2 Express with SMO

In our software because the users are using SQL Server 2008 R2 Express, I would want to create backup jobs for them programmatically using the SMO API. Is it possible? If possible point me to any articles written on this light of this topic.
Soham Dasgupta
  • 5,061
  • 24
  • 79
  • 125
0
votes
2 answers

Does SQL Server 2008 have any default mantenance plans?

I am using SQL Server 2008 Enterprise version. I want to know if I do not explicitly set any maintenance jobs, are there any default maintenance jobs SQL Server will perform (like backup? rebuild index? truncate transaction log?)? Where to find the…
George2
  • 44,761
  • 110
  • 317
  • 455
-2
votes
1 answer

How to copy database backup (created by maintenance plans) files to remote machine

I would like to copy backup files after MS SQL Server maintenance plan to a new shared folder in another server. How to do that??
Gherbas
  • 61
  • 2
  • 10
1 2 3 4 5 6
7