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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
131 views

Rails Site Maintenance/Monitoring

I am setting up a daily maintenance task for my rails app. When the task is complete is sends me an e-mail that summarizes the tasks activity. If you were doing the same, what kind of tasks would your ...
sosborn's user avatar
  • 103
0 votes
1 answer
88 views

advice on database index maintenance

I have a fairly large table, which I have to keep up, with some very, very fragmented indices. This seems to be causing problems with performance. I would like to have neat fresh crisp indices on this ...
Martijn's user avatar
  • 125
0 votes
3 answers
211 views

automated mysql maintaince

Is there a script doing mysql maintenance ? or how can i make it manually, using cron tab ? and what steps should a good mysql maintenance run ? (MyISAM)
Utku Dalmaz's user avatar
  • 1,359
4 votes
4 answers
8k views

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's user avatar
2 votes
1 answer
299 views

Sql server backups best practices. Too many files created?

I know this has been asked before, but I'm trying to understand this better. I traditionally used Backup exec to backup sql servers, but I now have two sql servers that are off-site and of course I ...
lysdexic's user avatar
  • 366
9 votes
6 answers
27k views

Daily/Weekly/Monthly/Annual Sysadmin Tasks

This should probably be community wiki. I'm trying to come up with a list of all the sysadmin tasks that we should be doing on a regular basis because I believe we're not doing enough at our company. ...
0 votes
3 answers
342 views

MSSQL2005 database hanging during maintenance

Our database server has a maintenance plan which runs each night: Back up databases & logs (10-20GB max) Check Database Integrity Rebuild Indexes Update Statistics Normally this all executes in ...
realworldcoder's user avatar
1 vote
1 answer
2k views

Getting SQL server 2008 to use Powershell 2

I have a server running Windows Server 2008 (not R2) and SQL Server 2008. I installed Powershell 2 and it works fine when running Powershell scripts. However when trying to run a Powershell script in ...
Chao's user avatar
  • 113
8 votes
4 answers
12k views

Freeing up space in my SVN repository

I have an SVN repository hosted on a freemium site with a maximum repository size. As I approach this capacity I am aware of files I've checked in that I know I can remove permanently to free up disk ...
fbrereto's user avatar
  • 323
2 votes
4 answers
216 views

How to handle a server upgrade

I have several website stored on a server. If I want to upgrade my apache configuration I want to inform all my customers that there will be an upgrade in 30 minutes. I can modify each website to ...
aneuryzm's user avatar
  • 1,754
2 votes
7 answers
1k views

MSSQL Server 10 runaway log growth, 100GB/week

I have started as an IT Manager and my remit covers MSSQL server. A database that I have inherited uses around 100GB of HD in the space of a week, in the LDF file. This in turn uses all available disk ...
Skeep's user avatar
  • 165
1 vote
3 answers
3k views

Answering all requests with a maintenance page without restarting Apache HTTP server

let say we have the following picture: A Apache HTTP server is serving the users' requests. It forwards all (or a part of) requests to a Tomcat server using mod_jk. Let's say we want to shutdown our ...
Igor Mukhin's user avatar
1 vote
1 answer
335 views

SQL Server 2005 TempDB Maintenace

I am working with a SQL Server 2005 database, which has the 8 files in 1 filegroup for the TempDB. The initial size of the 1st file is 8MB, and the other 7 are 2GB. This database is a reporting DB, ...
Dustin Laine's user avatar
0 votes
2 answers
147 views

run installer on all machines on domain

is it reasonable to automatically run an installer (for an activex control) as administrator on all machines in my domain, using an out-of-the-box windows (any version)?
Dustin Getz's user avatar
0 votes
3 answers
2k views

query maintenance plan schedule

can I query the schedule of a maintenance plan? I want to automate checking that backups were run. Thanks
user avatar
0 votes
7 answers
6k views

"Site Down for Maintenance" what kind of maintenance work do they do?

I'm a moderate web developer. I haven't managed any high traffic websites. Generally, I observe that only high traffic websites are down for maintenance. stackoverflow.com will also go down for ...
claws's user avatar
  • 232
0 votes
2 answers
952 views

How to export a MSSQL table in MSSQL studio express 2005?

is there any way to export a table to a file without any additional tools? I can't install anything on that server.
user avatar
0 votes
1 answer
115 views

How do i archive newly added DB backups?

I'm using Windows Server 2003, Sql-Server 2005 and 7-zip for archiving. Each day maintenance plan adds all DBs to backup and i need to archive those but just those files. How do i create .bat or ....
eugeneK's user avatar
  • 410
0 votes
1 answer
318 views

Advice on keeping cloud server secure? (linux)

I'm able to take a basic linux distro (stable Ubuntu Server) and install everything I need to get my web apps up and running. (Django, Rails, PHP etc...) But after all of that I would appreciate some ...
Todd's user avatar
  • 121
2 votes
3 answers
4k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
alex's user avatar
  • 1,730
1 vote
2 answers
736 views

Ubuntu server maintenance (apt-get dist-upgrade)

Over time I've generated a proliferation of Ubuntu servers, and its starting to get tiresome keeping them all up to date. If I SSH in a particular server, and notice it needs an update, I just fire ...
aidan's user avatar
  • 615
2 votes
3 answers
4k views

Shutting down web server for maintenance

Note: I am new to this situation! How do we manage to to redirect every request during maintenance to a page which says the site is under maintenance mode? I want to automate this process (through ...
Vishal's user avatar
  • 135
1 vote
1 answer
863 views

Check Database Integrity fails

My nightly maintenance plans are failing for two databases. I'm not even sure what this means. Any ideas on how to fix? Here's the error I have from the maintenance plan: Executing the query "DBCC ...
NotMe's user avatar
  • 3,782
2 votes
6 answers
403 views

Using mod_rewrite to shutdown website

I am trying to shutdown a website to everyone except my ip address. I almost have it working. I cannot access www.mysite.com, but I can access all folders that have another .htaccess file in them. I ...
user avatar
1 vote
1 answer
366 views

SQL restore from single file db to filegroup

I have a 180GB MOSS 2007 database whose maintenance (i.e. backups and restores) are becoming a problem. Part of the issue can be resolved by splitting the three content sites down into their own site ...
Mauro's user avatar
  • 213
8 votes
8 answers
3k views

What is the oldest hardware still in production use? How is it kept running? [closed]

In the spirit of the question What is your oldest hardware that still works?, I'd like to ask: What is the oldest hardware you know that is still in production use? And what challenges did you (or ...
3 votes
2 answers
509 views

Buying an old laser printer -- what will need to be replaced?

as you can see I'm new. I do IT and wiring for a small local shop but I never deal with printers. I do a LOT of printing, and I'd like to stop spending as much money on it. On my local CL, there is ...
themirror's user avatar
  • 289
0 votes
1 answer
367 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
Adam J.R. Erickson's user avatar
1 vote
1 answer
3k views

Active Directory Partition Error

Right now my active directory is failing a dcdiag test. I can find no info online about this error. When I run dcdiag /test:crossrefvalidation, I get the output: .... Doing primary tests ...
BLAKE's user avatar
  • 716
1 vote
1 answer
8k views

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
Adam J.R. Erickson's user avatar
2 votes
1 answer
512 views

What database is easy to maintain and manage in a cluster?

I'm looking for a database (DBMS) that is easy to scale out. I would like to have high availability so I need a multi-master cluster, where the data is replicated to two or more physical computers. I ...
Jonas's user avatar
  • 1,223
4 votes
1 answer
703 views

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 ...
markle976's user avatar
  • 147
10 votes
6 answers
4k views

How do *you* track and document routine maintenance?

What software or system do you guys out on server fault use to remind you to do routine maintenance? How do you checklist and log the various items you are supposed to check? Do you have an internal ...
Zak's user avatar
  • 1,042
3 votes
3 answers
198 views

SQL Server 2005 Default Backup Plan

I noticed that a newly imported database on SQLServer 2005 had configured itself (without my knowledge) to perform daily backups; but it's not deleting old files and quickly filling up the disk. I ...
tylerl's user avatar
  • 15.1k
3 votes
3 answers
2k views

How should I perform database maintenance on a 24x7 system

I'm a software developer who inherited a part-time DBA role. I'm responsible for an application backend by a small, high-volume 24x7 database on SQL Server 2008. While there's other stuff in the DB, ...
solublefish's user avatar
4 votes
2 answers
392 views

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 ...
harald's user avatar
  • 403
2 votes
1 answer
263 views

Graceful maintenance of web applications

I asked this question on Stack Overflow and got some good responses. A couple of SO members mentioned I should ask it here also to see what the SysAdmin perspective on this is. So here goes: I live ...
Ganesh Shankar's user avatar
6 votes
1 answer
8k views

How to check how many users are online?

I administer a ASP.NET website that has decent traffic. In the middle of the day, I sometimes would need to either redeploy the website, change the configuration in the web.config file or make some ...
user25164's user avatar
  • 421
1 vote
1 answer
3k views

Cleaning up AD and DNS on Windows SBS 2008

I searched serverfault.com for duplicates of this question but couldn't find anything close enough for my needs, so here goes. I'm administering a small Windows domain, where a Win SBS 2008 is the DC ...
user avatar
2 votes
4 answers
244 views

What are the periodic maintenance and security activities for a medium-large Active Directory Implementation?

What are the most common periodic activities that are to be performed to make sure that medium to large Active Directory implementation runs smoothly and securely.
Santosh Chandavaram's user avatar
0 votes
2 answers
99 views

Realtime MS SQL Database transfer

I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime. Is ...
user34402's user avatar
  • 271
4 votes
6 answers
4k views

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) ...
Sejanus's user avatar
  • 311
3 votes
3 answers
14k views

SQL Maintenance Plan - Send email on fail

I have a maintenance plan on my SQL 2008 box - I would like it to send an email address when (or if) it fails. I've set up database mail, and can send a test email.. How can I do this?
alex's user avatar
  • 1,730
3 votes
4 answers
19k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
user avatar
0 votes
1 answer
351 views

MSSQL:Ultimate configuration for rebuilding indexes+statistics

My database is growing slower even though I have a bunch of indexes setup. Yesterday I figured out that I need to setup a maintenance plan to build the indexes etc. So my question is what's the ...
Niels Bosma's user avatar
0 votes
1 answer
10k views

Maintenance Cleanup Task(s) running 'successfully' but not deleting back up files

I have a maintenance plan setup for all my user databases on a particular server, which does all the usually things at various intervals. The 7th and final subplan is a two stage cleanup plan; ...
CJM's user avatar
  • 730
2 votes
1 answer
3k views

Keeping SQL Express below 4gb?

What would the recommended best practices to keep a SQL Express 2005 database below the 4gb limit? I am willing to export and archive content out of the data tables, but am not sure this will help ...
datatoo's user avatar
  • 351
1 vote
3 answers
2k views

Is there a query to check which maintenance plans have shrink enabled in SQL Server 2008?

I know you can use a query to find out which databases have auto-shrink enabled but I'm wondering if this can be done for maintenance plans. Right now we only have a few maintenance plans so it's easy ...
Shane's user avatar
  • 1,889
1 vote
5 answers
3k views

What is the proper way to keep Ubuntu Server 8.04 updated?

I have a web server running Ubuntu Server 8.04 and I would like to know the proper commands to keep it updated. I’ve been using apt-get update and apt-get upgrade, but occasionally it tells me that ...
Corey's user avatar
  • 2,081
12 votes
9 answers
5k views

Should old servers be retired

I have servers which are still running well but are over 5 years old. They are still doing the job perfectly and there will be no advantage to upgrade the servers, should I just let them run forever ...
simplr's user avatar
  • 520