[dba-Tech] Corrupted Word file

jwcolby jwcolby at colbyconsulting.com
Thu Oct 25 11:24:18 CDT 2007


I just bought three 1500 VA 900 W units.  I did actual tests and got around
14 minutes providing voltage for a server with 8 hard disks, dual proc, 4
gigs of ram.  Just the server, no monitor.  I provided each of two servers
their own UPS and then put the monitor on its own UPS.  The monitor is on a
KVM switch.  With that setup I can handle most stuff.  I actually bought an
auto-start propane powered backup generator which powers my office as well
as much of the rest of the house so I probably could have gotten by with
smaller UPS' but why risk it?

According to statistics most outages are for only a few seconds but of those
that last more than that most are for only a few minutes.  14 minutes is
enough to finish most tasks, but my servers run SQL Server and I can tell
you from experience that they do not like to lose power in the middle of
write operations.  I managed to get the database back when it happened but I
had to go find out about (built in to SQL Server) recovery operations on the
data file.  Scary stuff.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond
Sent: Thursday, October 25, 2007 12:03 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Corrupted Word file

Just to add to the UPS discussion.  I've come across the Belkin UPS's at
Buy.com (search for Belkin UPS at buy.com's website).  I just paid $145 for
a 1500va UPS.  This is the second one I've purchased and both have been for
small business servers.  The first one I setup has been put to good use
several times in the last year as the power where it is installed is down
quite a bit.  From the reviews I've read about them, the length of time they
will provide power at full load is exaggerated but for the price they can
protect a good amount of equipment long enough to shut it down gracefully.
It even comes with a serial and usb cable to connect to your computer and a
$30 mail-in rebate.


----- Original Message ----
From: John Bartow <john at winhaven.net>
To: Discussion of Hardware and Software issues
<dba-tech at databaseadvisors.com>
Sent: Thursday, October 25, 2007 10:09:14 AM
Subject: Re: [dba-Tech] Corrupted Word file


About 8 years ago I lost 1/2 hours worth of work on a PowerPoint right
before I had to leave for a presentation. I've never had a power  related
file problem again - because I went out and bought a UPS ;-)

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan  Harkins

=====Circuit breaker flipped. :( I have the text, so I'll just start
reformatting it. The file was saved, but it was open at the time.


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list