Re: Are multiple transaction logs used concurrently or sequentially?

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 08:21:50 -0400

The way the SQL Logs work is sequential... Even if you have 5 logs, SQL is
only using one at a time, writing serially to the end of the file... So
having multiple files does not improve performance.

Mirroring is probably the best way to get redundancy on the logs, and it is
a best practice that I suspect most people follow.

There is some file mirroring software out there ( I can't remember the
company ) that keeps files in sync real-time, and they claim this works with
SQL as well... 

-- 
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
"fumanchu" <leondobr@verizon.net> wrote in message
news:rjvtn0tjdv3afv74bv33t3k9ueng4fg7ml@4ax.com...
> It'd be nice to have redundant transaction logs, maybe even one on a
> mapped drive, but I read in one post here that SQL Server considers
> all transaction logs to be one big log file. Is this true?
>
> Is there any way to have redundant transaction logs without mirroring>

Relevant Pages

  • Re: Migrating logs to SAN
    ... In SQL 2005 this might work as long as the same drive structure is observed, and you have the same database IDs. ... We'd like migrate the logs from the local ... Stop the SQL server ... Assign the SAN device the drive letter previously claimed by the local ...
    (microsoft.public.sqlserver.replication)
  • Missing DLL during re-installation
    ... The installation appeared to complete successfully and I ... SQL Server Setup failed to execute a command for server configuration. ... Refer to the server error logs and Setup ...
    (microsoft.public.sqlserver.setup)
  • Re: testing vulnerable web application.
    ... You should be able to just open up your logs and look for things that are out of the ordinary. ... Keep your database and all but double check it to make sure there really aren't accounts and what not that should not be there. ... We assumed the attacker was using some sort of SQL injection to alter the DB records or possibly he can craft a SQL query in a way that will create an admin account to use to simply log in and alter the records and then delete his username...NO rogue admin accounts have ever been found. ... You have an option to go with a managed service or an enterprise software. ...
    (Pen-Test)
  • Re: Where did the connections come from?
    ... Actually we've seen varioius login failures. ... It would be great for the SQL logs to include the information like ... trusted SQL server connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to start SQL SERVER service for a SQL EXPRESS instance.
    ... Event Viewer, as you directed), so that's what that said. ... As for the SQL Error Log, there don't appear to be ANY logs. ... Now, it won't install completely. ...
    (microsoft.public.sqlserver.clients)