Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?My server stuff is a bit rusty but I don't believe you can
have a remote mirror, mainly due to network traffic.
Have you though of backing up your database (files and
logs) onto a different server.
J
>--Original Message--
>How to protect the transaction logs from disaster
considering the loss
>of hardware mirror? Can we use remote mirror for these
files?
>.
>|||tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shipping:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid array?
> RAID-1 is commonly used for transaction log protection - this cannot be used
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > How to protect the transaction logs from disaster considering the loss
> > of hardware mirror? Can we use remote mirror for these files?|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.com...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> > tram,
> >
> > Back them up frequently, say every 5 mins? You can also deploy log
shipping:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> >
> > Do you have redundancy at the disk level? Have you implemented a raid
array?
> > RAID-1 is commonly used for transaction log protection - this cannot be
used
> > remotely though, it is local to the server.
> >
> > See:
> > http://www.acnc.com/04_01_01_flash.html
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> >
> >
> >
> > "tram" <tram_e@.hotmail.com> wrote in message
> > news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > > How to protect the transaction logs from disaster considering the loss
> > > of hardware mirror? Can we use remote mirror for these files?