Francisco Tapia
fhtapia at gmail.com
Fri Sep 8 13:23:05 CDT 2006
If the raid 5 is a software raid you will need to recreate it from the OS which you say you are backing up. Personally I would use Acronis for the backups it seems to do a much better and reliable job than ghost (ymmv). IF the raid is a hardware raid then you do not really stand to loose it you just point the OS to the logical drive and you are off and running. My current db backups have not yet reached a number like yours, I backup to a local drive and have that get backed up to tape, then again to another system as a zip file. On 9/7/06, JWColby <jwcolby at colbyconsulting.com> wrote: > 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 > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More...