[dba-SQLServer] How does it work

JWColby jwcolby at colbyconsulting.com
Thu Sep 7 21:47:16 CDT 2006


I have now successfully created a Raid5 on my new server.  For the moment it
is a 4 disk array using 320g drives for a total size (available) of around
900g.  I will be adding another pair, one of which will be a hot spare,
which will bump it to 1.2g available and one drive just sitting there for
(automatic) use in a failure.  
 
My question now is, if I place all of the SQL Server database files (not the
program files, but the database files FOR SQL SERVER) as well as the actual
files for the various databases and their logs, if I place all that stuff
out on this mongo raid drive, and then my boot drive dies... can SQL Server
be installed to use an existing set of files?
 
I actually have one more SATA connector which I intend to use to copy an
image of the boot drive once a week or so (maybe even nightly), so that if
the boot drive dies I should be able to get back up with a minimum of pain.
For that I will need Ghost or something similar running as a scheduled task.
 
And then of course there is the issue of "what happens if the house burns
down".  How do you conveniently back up a large db offsite?  Or in a fire
safe?  I actually read about a rather expensive 
 
A while back I actually purchased this SQL Server backup program called
Imceda Litespeed (now sold I believe) which does a great job of backing up
large databases, compacting on the way out.  I am thinking about setting up
a small machine down in the basement at the far end of the house, on the
other end of a 1gbit line, and have Litespeed place the backup file on hard
disks on that machine.  Even at 10:1 compression which it seems to do, an
800gb database turns into an 80gb backup file.  Over a 1gbit line that will
take an hour to copy the backup file.
 
If you folks do this kind of stuff how about starting a discussion of how
you handle it.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 


More information about the dba-SQLServer mailing list