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.
247
questions
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 ...
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 ...
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)
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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)?
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
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 ...
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.
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 ....
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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
...
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"?
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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) ...
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?
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 ...
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 ...
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; ...
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 ...
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 ...
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 ...
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 ...