Re: Transaction log

From: tram (tram_e_at_hotmail.com)
Date: 05/19/04 

Date: 18 May 2004 18:05:16 -0700

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: 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)
  • Re: SQL 2005 Mirroring Problems, HELP
    ... Mirror: MSSQL 2005 x64 Enterprise Editon with SP1 ... CREATE ENDPOINT Mirroring ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ... but NOT on three diffrent SQL Server. ...
    (microsoft.public.sqlserver)