Server Fault Stack Exchange
Server Fault Stack Exchange

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
1
vote
1 answer

Removed SQLServerAgent account What should I do ?

I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be started (reason: Error creating a new session). . I…
xp11
  • 13
  • 3
1
vote
4 answers

Server CPU spikes suddenly and becomes unusuable - Tips to monitor/analyze this?

my server has been going down over the last 24-48 hours, CPU spikes from 15% to 100% and server becomes unusable and all my sites go down as a consequence of it. Any tips on how I could track what is going on on my server? Any suggestions on…
RadiantHex
  • 547
  • 2
  • 9
  • 18
1
vote
1 answer

Setting up Ola Hallengren's sql jobs

I've installed Ola Hallengrens Maintenance scripts and it has created the jobs for me. DatabaseBackup - SYSTEM_DATABASES - FULL DatabaseBackup - USER_DATABASES - FULL DatabaseBackup - USER_DATABASES - DIFF DatabaseBackup - USER_DATABASES -…
Robin Day
  • 506
  • 1
  • 8
  • 19
1
vote
2 answers

Rebuild index --> update statistics?

If I run Rebuild Index Task in maintenance plan, do I have to update statistics using Update Statistcs Task?
hjk
  • 17
  • 2
  • 5
1
vote
4 answers

Holding page whilst apache down/restarted

Is there a way to have a holding page saying something along the lines of "The site is down don't panic" - just a static html page, nothing fancy, when apache is restarted or goes down? If it is possible how would I go about doing it? Would it…
m4rc
  • 133
  • 4
1
vote
1 answer

General High-Level Assessment

Guys and Gals, I've been tasked with a doozy of an assignment. The objective is something akin to "laying of hands" on several database servers which work in concert to provide data to various Web, Client-Server and Tablet-Sync'd distributed…
tcarper
  • 11
  • 2
1
vote
1 answer

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 a SQL Job it appears to run using Powershell v1…
Chao
  • 113
  • 4
1
vote
3 answers

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 application on Tomcat for two hours for…
Igor Mukhin
  • 175
  • 3
  • 6
1
vote
1 answer

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, which is populated nightly from an SSIS package.…
Dustin Laine
  • 433
  • 4
  • 13
1
vote
2 answers

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 off sudo screen -d -m apt-get -y dist-upgrade and…
aidan
  • 615
  • 4
  • 10
  • 23
1
vote
1 answer

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 CHECKDB(N'Site_DB') WITH NO_INFOMSGS " failed with…
NotMe
  • 3,772
  • 7
  • 31
  • 43
1
vote
1 answer

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 collections, however this will likely still…
Mauro
  • 213
  • 1
  • 9
1
vote
1 answer

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 Testing server: Default-First-Site-Name\ad01 Running…
BLAKE
  • 706
  • 10
  • 26
1
vote
1 answer

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
  • 147
  • 2
  • 6
1
vote
1 answer

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 and a Win Server 03 acts as our print and file…
Joshua R
1 2 3
…
16 17