Re: Dynamic backup on removable drive?

From: Etienne Charland (mystery@golden.net)
Date: 12/03/02 

From: "Etienne Charland" <mystery@golden.net>
Date: Tue, 3 Dec 2002 14:19:57 -0500

And what if I splited the removable drive in multiple partitions and used
rotation to save data? One of the partitions would contain older data. Also,
I would backup the database often, so even if the system is fully crashed on
both drives and the SQL Server's database is corrupted, I could restore an
older database. But I don't know how to setup something like that... I only
have a vague idea of how it could be, but I don't know how it would be the
best.

"Toni Lassila" <mpao@mc-europe.com> wrote in message
news:b11796dd.0212022339.3f91af1f@posting.google.com...
> "Etienne Charland" <mystery@golden.net> wrote in message
news:<OH9k$khmCHA.2360@tkmsftngp07>...
> > Is there a way to configure a server like this? I would have 2 hard
drives,
> > and one of them is removable, so we can go with it. So, when we remove
the
> > hard drive before going, the system should continue to run, and when we
> > insert it back in the morning, it would have to update all the changes
that
> > happened during the night, or during the few days.
>
> If it's a hot swap capable drive I guess you could set up a RAID-1
> or just use W2K disk management to mirror the partition on both drives.
> Depending on your hardware and the driver support for it, this might
> or might not be safe. Some people say they've successfully pulled it
> off, others report hardware failures.
>
> Also consider that if something goes wrong with the live disk and
> you don't notice it, when you plug in the mirror disk the bad data
> will overwrite the good data. Consider keeping a backup archive on
> tapes in case you have to go further back than just the previous
> night.

Relevant Pages

  • Re: Oracle Performance -- Possible Disk Bottleneck
    ... I've read that 15k drives can perform 180 IO's per second. ... confirm this is a disk bottle neck. ... so I'm hoping someone here has experience with SANs and ORACLE to help ... this is a disk bottleneck and that giving the database more spindles ...
    (comp.databases.oracle.server)
  • Re: Transfering XP system files into a larger HDD
    ... If both drives are connected, ... If *only* your working drive (the source disk) is connected at the time the computer is running, insert the Acronis bootable CD in your CD/DVD device and shutdown your computer. ... I have the USB external drive in two partitions, one with nothing and the same size as the partition I am using for XP and programs. ...
    (microsoft.public.windowsxp.general)
  • Re: gmirror disks vs partitions
    ... Apart from potentially avoiding a whole disk from being copied ... You divide a couple of identical drives proportionally ... in two partitions each, place a couple of the first ... partitions into gmirror and a couple of the second ...
    (freebsd-stable)
  • Re: sqlserver 2005: indexes on raid-0?
    ... place all tables/indexes on a massive raid-10 array, ... My philosophy is quite the opposite for a general purpose database server. ... over available disk storage so that I/O is evenly distributed over the I/O ... I've seen a SQL 2005 demo with files on removable drives that may provide ...
    (comp.databases.ms-sqlserver)
  • Re: Recycle Bin - Add a drive to...
    ... Are they two drives or one drive divided into two partitions. ... see which in Disk Management. ... I don't know what Tool/Utility was used to create the partitions. ... Right click on the Recycle Bin on your Desktop and select ...
    (microsoft.public.windowsxp.general)