Questions tagged [maintenance]

maintenance is keeping hardware and/or software systems in a healthy state by performing tasks such as updating, cleaning or replacing parts.

maintenance is keeping hardware and/or software systems in a healthy state by performing tasks such as updating, cleaning or replacing parts.

245 questions
5
votes
4 answers

MySQL: Hunting down unused databases

Is there any commands to look up databases that has no any activity in a month or so? Just take SQL dumps for a month and run diff and if there's no differences delete that DB?
raspi
  • 811
  • 1
  • 9
  • 21
4
votes
1 answer

Restart Systemd unit after dependency

I have a web application that is started by systemd. It uses Postgresql as database, so it rely on it. Here is the unit file of my web application (I have remove the un-relevant/sensitive…
4
votes
1 answer

What is required in installing/maintaining a software package on a production server?

A coworker of mine and I are discussing the use (or not) of a full text search solution, namely Elasticsearch in our web application. I am the developer of the web application, and he manages the production server, which is a single Intel NUC…
4
votes
4 answers

Creating a SQL server Maintenance Plan without the wizard

Is there a way to generate a SQL server maintenance plan that will be the same as the one generated by the wizard, but without going through the wizard dialog. I need something that can be created automatically as part as an install process. Also,…
Ron Harlev
  • 243
  • 1
  • 8
4
votes
2 answers

What is the best way to keep track of changes people are making to your servers?

HI Folks, I work at a company with a handful of windows servers in production running our software as a service offering. Part way through making a bunch of changes such as creating new Databases, moving database files round, setting up logins and…
Robin
  • 817
  • 3
  • 11
  • 20
4
votes
3 answers

How can I physically clean out dirty desktops and servers?

In an attempt to keep operating temperatures and fan noise down how can I clean out servers and desktops that have accumulated dust in their cases, heat sinks, and other crannies? Is there any way that I can slow the accumulation of dust in PCs on…
jdiaz
  • 1,189
  • 3
  • 16
  • 16
4
votes
3 answers

SQL Server 2005: Proper Backup Schedule

I'm a .NET Developer and I know how to write SQL but am clueless at doing any form of database maintenance scheduling yadda So, I've recently taken over a project from a previous client. The site is hosted with Rackspace. Anyway, the previous…
Jack Marchetti
  • 561
  • 1
  • 6
  • 15
4
votes
1 answer

General SLA Expectations and Maintenance for Standard Services

What would generally be your expectation for SLA uptimes across the following services in a given month for a 'normal' scenario? I'm including my expectations... the purpose of this question is to find out what the standard baseline should be in…
Brandon
  • 2,817
  • 1
  • 24
  • 28
4
votes
25 answers

What do you do to prevent stupid mistakes?

I saw this comment: "Been there, done that. We aliased the killall-command on the solaris-boxes after that: alias killall='echo ORLLY?' =) – Commander Keen May 28 at 12:03" In response to an answer. It made me wonder, what do sysadmins do…
jtimberman
  • 7,587
  • 2
  • 34
  • 42
4
votes
4 answers

How to temporariliy disable access to Oracle database?

I would like to be able to temporarily disable all access to an Oracle database, except my own, to be able to perform maintenance actions without interruptions. Simplest way?
Arne Evertsson
  • 185
  • 3
  • 13
4
votes
6 answers

Printer Maintenance Kits?

I've got an HP Laserjet 2430tn that supports a staff of approximately 15 people. It has over 207,000+ pages printed in its lifespan so far. It needs new rollers, as the paper jams more and more. A "maintenance kit" for this printer looms around…
bobby
  • 604
  • 4
  • 13
4
votes
6 answers

receiving mail during Exchange maintenance?

I was part of a small company, and sometimes we had to bring down our Exchange server to perform maintenance. The majority of mail during the downtime would get redelivered in a timely manner, but sometimes important emails would take days to…
Joseph
  • 3,797
  • 27
  • 33
4
votes
1 answer

What is the typical maintenance required on a LAMP server?

I am in the process of setting up an Ubuntu LAMP server (cloud hosted) to run a few small websites. I am in the process of configuring the security settings, etc. Once I have it ready for production what types/amount of maintenance will I need to be…
markle976
  • 147
  • 4
4
votes
2 answers

looking for a clean way of how to bring down a ftp server for maintenance

i'm currently thinking of a clean way of how to bring an ftp server down for maintenance. i wonder, if anybody out there could give me some hints of how to solve this: i don't want to interrupt any current uploads, but want to block any new…
harald
  • 403
  • 2
  • 6
  • 19
4
votes
6 answers

How to do scheduled Linux server backup

I need to organize automated backup for databases, websites, ftp, email, etc. at Ubuntu 9.04 and since I've never done it before, I'm looking for places to learn. What needs to be done, what (free) software I could use, tips&tricks, best practices…
Sejanus
  • 311
  • 1
  • 4
  • 12