Re: Transaction log

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 05/19/04 

Date: Tue, 18 May 2004 23:19:16 -0400

That's what log backups are for. The backups are usually placed on another
SAN so you have DR. You can also use SAN based features such as SRDF to
mirror data across datacenters. 

-- 
Andrew J. Kelly  SQL MVP
"tram" <tram_e@hotmail.com> wrote in message
news:26ee1067.0405181705.da01b48@posting.google.com...
> Wayne,
>
> How could we mirror local disk with remote disk/disk on SAN? Our
> concern is if we lose local one, we should able to get active log info
> from the other mirrored drive which is not at same place as the failed
> one.
>
>
>
>
> "Wayne Snyder" <wsnyder@computeredservices.com> wrote in message
news:<utgR8oQPEHA.4036@TK2MSFTNGP12.phx.gbl>...
> > I don't really understand the distinction you are making ( but I don't
know
> > Oracle..)  If you mirror the log you can place each mirror anywhere you
> > wish...
> >
> > -- 
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> >
> > "tram" <tram_e@hotmail.com> wrote in message
> > news:26ee1067.0405181016.2450bc87@posting.google.com...
> > > Protecting on line log is most important for any DBMS.Is Yukon has
> > > dual logging facility? Why Microsoft is not working on this similar to
> > > oracle and DB2? Microsoft is suggesting us to use mirror for logs and
> > > in case of disaster, we lose data with mirror. With dual logging, we
> > > can isolate both logs. Any ideas?

Relevant Pages

  • RE: Auto Failover & DR >>
    ... database mirroring and log shipping both works on transaction logs. ... DD - SQL server 2005 ... principal and mirror are needed. ... adding the witness to a high ...
    (microsoft.public.sqlserver.clients)
  • Re: Linux LVM software raid, and SAN question.
    ... you need massive redundancy supplied by two SAN devices, ... Software raid to mirror the luns from both sans, ... LVM to mirror and handle the whole damned thing? ... which goes to a storage port on the array. ...
    (comp.arch.storage)
  • Re: SQL 2005 hardware recommendations
    ... Actually, RAID 1+0 is mirror, then stripe, not the other way around. ... I can even lose disk 5 or 6 and still function. ... partitions and sizes for the installation of SQL Server 2005 ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Mirroring - Log file size management
    ... These can lead to fragmentation which showcontig will show. ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Getting this over to my mirror isnt a problem as whilst its a WAn ...
    (microsoft.public.sqlserver.replication)
  • RE: Auto Failover & DR >>
    ... Can I use Database Mirroring and Log Shipping together to achieve automatic ... principal and mirror are needed. ... which requires two or more SQL Server instances. ... if I go with automate failover that means I have to configure ...
    (microsoft.public.sqlserver.clients)