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
1
vote
3 answers

What are the first steps in hardening a legacy Rails application?

There is a production system that has been running for many years, first as a PHP application, then as a hybrid with Rails, and now completely in Rails. It's unclear how long it has been around. The oldest git commit is from 5 years ago. The goal is…
Reed G. Law
  • 3,897
  • 1
  • 41
  • 78
1
vote
2 answers

SQL Server 2008 Maintenance Plan Backup List

I'm working on a Maintenance Plan for doing Backups on my server. I just want to know if SQL Server maintains a list of the backup files that were created during the backup process? Thanks a lot!
Smiley
  • 3,207
  • 13
  • 49
  • 66
1
vote
2 answers

wicket 1.5 end of life

I am trying to find authoritative answer to the following questions: Is Wicket 1.5.10 the last release there will be and are security fixes being downported to the 1.15 code branch? On the official distribution site I see there are no new releases…
gdanov
  • 312
  • 2
  • 12
1
vote
1 answer

Database Maintenance

I am trying to do some basic maintenance on a SQL Server 2005 database. It's fairly small (10gb in size, 50 tables or so). I am first doing the following on all tables: update statistics [table name] with fullscan followed by reindexing all…
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
1
vote
1 answer

What is an ideal way to put a Java Web Application (Struts) into Maintenace mode?

Like all CMS systems like wordpress, Drupal has maintenance mode where user see custom message indicating site is been offline for maintenance. How can I do that in my web application made using struts? My ideas: 1) Design separate web application…
Rameez
  • 1,712
  • 2
  • 18
  • 39
1
vote
1 answer

Maintaining a Caching Appliance

What are typical cache appliance maintenance tasks and schedule for same?
Maria Abrahms
  • 11
  • 1
1
vote
3 answers

SQL Server 2005 Shrink and Rebuild indexes

We have a weekly maintenance plan to shrink all user databases and rebuild their indexes. This has working fine until we created a read-only database, now each time the plan runs it fails when it starts processing this database due to its read only…
Neil Redfern
  • 11
  • 2
1
vote
0 answers

Only one Storyboard for iPad and iPod/iPhone devices

I've just started building an universal iOS app, and it looks like having two separate storyboards for the iPad and iPod/iPhone could be a bit of a maintenance issue because the only difference between most of the View Controllers is the size. Also…
RohinNZ
  • 3,338
  • 5
  • 24
  • 34
1
vote
1 answer

Maintenance plan duration shown in history

Here is an export of our sql 2005 maintenance plan history Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration 06/07/2009 05:08:29,,Unknown,Weekly optimisation,Subplan_1,,05:08:25 06/07/2009 05:07:41,,Unknown,,,Shrink Database Task…
Sebastien
  • 570
  • 3
  • 5
  • 18
0
votes
2 answers

How to retrieve all indexes in a database along with their data types in SQL Server 2005?

I have a maintenance task that's failing because there are a few indexes on the database that have a type which does not allow online rebuilding of the index. Offline is not an option in my industry, so I have to create my own T-SQL task that does…
stringpoet
  • 164
  • 4
  • 14
0
votes
2 answers

Special Maintenance Plan Query

The Maintenance Plan creation is easy. Every body simply use the Maintenance Plan Wizard. But in this case I want to write program to create a Maintenance Plan using Query. My plan is Recurrence Full Backup. I used Profiler to detect related queries…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
0
votes
5 answers

What is the use of maintenance plans in SQLSERVER2005

What is the need and use of sqlserver maintenance plans and how to configure them?
Cute
  • 13,643
  • 36
  • 96
  • 112
0
votes
1 answer

Maintenance Plan Fails But Query Runs

I have an SQL Server 2005 Enterprise Edition whose Maintenance plan fails constantly with the error: backup MYSERVER (MYSERVER) Backup Database on MYSERVER Databases that have a compatibility level of 70 (SQL Server version 7.0) will be…
Lynx Kepler
  • 662
  • 1
  • 9
  • 21
0
votes
0 answers

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 of the attached image: enter image description…
Matheus de Freitas
  • 1
  • 1
0
votes
0 answers

Is there a known API or module to automate Start/Stop activity for IBM WebSphere application servers with RPA?

I need to automate the start/stop activity for some application servers in IBM WebSphere. Is there any api or module using which I can perform this using a RPA bot? This is a part of a use case to set up a pipeline that will automate the monthly…
Navneet Das
  • 1
  • 1
1 2 3
4
5 6 7