The tag has no wiki summary.

learn more… | top users | synonyms

14
votes
5answers
2k views

What is a reasonable maintenance schedule for Windows PCs?

I am in charge of maintaining around 25 PCs with various versions of Windows (Vista, 7, 8). I was thinking something along the following lines: Every 4–6 months: Take an image of the system ...
0
votes
2answers
277 views

How to prevent nginx throttling conflicting with maintenance mode?

We use the HttpLimitReqModule nginx mondule for rate throttling and have found that it conflicts with our "maintenance mode" because both components are using http status code 503. When throttling is ...
0
votes
1answer
589 views

How to forward to Amazon S3 when in maintenance mode with nginx using 503?

During website maintenance, it is sometimes necessary to shutdown our website. Our current method is to touch a file which will trigger the web server (nginx) to redirect traffic to a maintenance ...
12
votes
3answers
341 views

Heat Sink compound and older desktops and workstations

This is my first question asked on SF, so be gentle kids. As my desktops (approximately 110 or so) have begun to age and with my users resisting Windows 8, I've begun to notice an odd trend. We are ...
0
votes
0answers
128 views

Can't select database for transaction log backup in maintenance plan

I am running into a problem while trying to save a transaction log database backup maintenance task: Add the 'Back Up Database Task' to the maintenance plan. Edit the task. Select backup type: ...
0
votes
1answer
239 views

Setting Up nginx Site Down That Responds Differently to Ajax?

I am trying to set up an automatic site-down page for nginx. So far I have this: location / { try_files /sitedown.html @myapp; } location @myapp { ... } ...
1
vote
1answer
1k views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
0
votes
1answer
29 views

Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times

SQL Server 2005: I have a problem with scheduling a Maintenance Plan (MP) with 3 subplans (SP). SP1 is scheduled to run hourly, SP2 daily at 7.00 and SP3 on sundays at 8.00 Reading MP history I ...
2
votes
1answer
384 views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
7
votes
1answer
436 views

Supermicro server onsite maintenance

We are considering moving from Dell to Supermicro servers. The main concern from management is what to do with maintenance. What do you guys do for same day onsite service maintenance plans?
2
votes
2answers
807 views

Reindex job failing due to being victim of a deadlock, but it is the only process running at 3am..?

I have a reindex job in a maintenance plan which I run on every table in a given database at 3am so it won't interrupt any other work. However it is failing and reporting the reason as being the ...
2
votes
2answers
95 views

Why isn't my SQL Server 08 Maintenance plan running at all?

I have this maintenance plan scheduled on my SQL Server 08... however, it never runs! It's been setup for 2 weeks now and I have not seen a single backup created, what am I doing wrong? How do I get ...
2
votes
2answers
190 views

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored ...
2
votes
1answer
223 views

What's a good data center failure “back up plan”?

With Amazon EC2 down right now, I figured this is a good time to ask the question. We've got all of our services hosted on EC2 at the moment and as a result, nothing is responding at all. Ideally, ...
0
votes
2answers
148 views

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding ...
3
votes
2answers
671 views

Can I Run SQL Maintenance plan to rebuild indices anytime?

Can I Run a maintenance plan that does Index Maintenance anytime? I've got a slow database right now and I have a index maintenance plan that is set to run every week. I did database update ...
0
votes
1answer
616 views

Email Daily Maintenance Plan Report

Im currently running a Maintenance Plan on SQL Server that does the following: 1 daily full backup Hourly transaction log backup 1 daily maintenance cleanup On the reporting options I have it set ...
0
votes
2answers
902 views

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still ...
0
votes
1answer
4k views

SQL Maintenance Cleanup Task 'Success' But not deleting files

I have a maintenance plan setup for a databases on a server. As part of the backup is a Maintenance Cleanup Task. SQL Version 2008 The task that 'succeeds' is setup as: Delete backup files Correct ...
2
votes
2answers
191 views

Scheduled Server Maintenance Holding Page

we are going to perform scheduled maintenance on our server, which runs IIS etc. We may need to restart the server to update Windows etc. I am wondering if it is possible to configure our DNS records ...
1
vote
2answers
1k views

Rebuild index --> update statistics?

If I run Rebuild Index Task in maintenance plan, do I have to update statistics using Update Statistcs Task?
1
vote
1answer
90 views

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, ...
2
votes
1answer
170 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 ...
1
vote
1answer
1k 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 ...
0
votes
3answers
470 views

query maintenance plan schedule

can I query the schedule of a maintenance plan? I want to automate checking that backups were run. Thanks
1
vote
1answer
402 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 ...
0
votes
1answer
296 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, ...
0
votes
1answer
2k 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"?
10
votes
5answers
1k 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
3answers
169 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
2answers
142 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
2answers
2k 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?
0
votes
1answer
5k 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; ...
1
vote
3answers
541 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 ...
11
votes
9answers
2k 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 ...
2
votes
2answers
420 views

SQL Server 2005 backup from non-domain computer?

We need to make a backup of a MS SQL Server 2005 database. The computer on which the database resides is in it's own workgroup and is not on our domain. It also doesn't appear the vendor will support ...
2
votes
1answer
476 views

zpool upgrade planning (time, I/O usage, etc.)

I recently upgraded our SXCE svn_72 box to OpenSolaris 2009.06 (snv_111b). It wants to me to upgrade my zpool to the latest version now. We need to plan upfront for things like zpool scrub because of ...
1
vote
4answers
320 views

SQL Server 2005 - Logs not being deleted

I have a SQL Maintance Plan that is set to backup my transaction log. I have it set to expire the transaction log after 2 days. The transaction log get created fine, but the old ones never get ...
1
vote
3answers
1k views

How can I do this to a Maintenance Plan

i've got a pretty simple maintenance plan that does a full backup of my db to a network'd location. works perfectly. I'm wanting to 7zip the backup file AFTER the backup was done. Is there a way i ...