Hello:

Is it OK to have ldf files on a RAID 0 drive?

childofthe1980s

It depends. If you are looking for only performence but not redundancy for
your t-log then go with the RAID0.

If you are looking for performance and redundancy for your t-log then I
suggest you to use RAID1 for your t-log.

--
Ekrem Önsoy



"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:50E6580B-AABF-4D2C-BE1F-466CCB1CCF62@microsoft.com...
> Hello:
>
> Is it OK to have ldf files on a RAID 0 drive?
>
> childofthe1980s
>
>

Just to add a little bit to Ekrem's comments.

If there's anything where you want redundancy, then it is the log files. If you lose the mdf file,
you still backup the log, and have zero data loss. If you lose the log file, well, you can't do a
backup of the log...

Of course, above assumes full recovery model and that zero data loss is something you aim for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in message
news:50E6580B-AABF-4D2C-BE1F-466CCB1CCF62@microsoft.com...
> Hello:
>
> Is it OK to have ldf files on a RAID 0 drive?
>
> childofthe1980s
>
>

Is it OK to loose data?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:50E6580B-AABF-4D2C-BE1F-466CCB1CCF62@microsoft.com...
> Hello:
>
> Is it OK to have ldf files on a RAID 0 drive?
>
> childofthe1980s
>
>

Sarcasm is extremely unprofessional. And, it's the worst form of "mentoring"
that there is.

This posting is supposed to be a friendly place where people can I ask
questions and discuss ideas.

This is the second time on this newsgroup that a "professional" has been
rude when I ask a question.

If any Newsgroup admins review these postings, please take action.

childofthe1980s

"Andrew J. Kelly" wrote:

> Is it OK to loose data?
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
> message news:50E6580B-AABF-4D2C-BE1F-466CCB1CCF62@microsoft.com...
> > Hello:
> >
> > Is it OK to have ldf files on a RAID 0 drive?
> >
> > childofthe1980s
> >
> >
>
>

That wasn't sarcasm, it was a valid question. You provided no information
what so ever, you just posed a question to which it is impossible to answer
correctly without more information. There are plenty of systems that don't
require the stability logs provide. For instance a DataMart that gets
rebuilt each night. As a matter of fact many DW type systems use Raid 0 for
the speed of writes and the fact that less disks are required. Maybe before
you jump to conclusions you should consider providing more detail so people
can give more directed answers without assumptions.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:13FB21B2-8DF7-4224-B461-935923FDC10C@microsoft.com...
> Sarcasm is extremely unprofessional. And, it's the worst form of
> "mentoring"
> that there is.
>
> This posting is supposed to be a friendly place where people can I ask
> questions and discuss ideas.
>
> This is the second time on this newsgroup that a "professional" has been
> rude when I ask a question.
>
> If any Newsgroup admins review these postings, please take action.
>
> childofthe1980s
>
> "Andrew J. Kelly" wrote:
>
>> Is it OK to loose data?
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>>
>> "childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
>> message news:50E6580B-AABF-4D2C-BE1F-466CCB1CCF62@microsoft.com...
>> > Hello:
>> >
>> > Is it OK to have ldf files on a RAID 0 drive?
>> >
>> > childofthe1980s
>> >
>> >
>>
>>

childofthe1980s wrote:
> Hello:
>
> Is it OK to have ldf files on a RAID 0 drive?
>
> childofthe1980s
>
>
It's no OK to have, IMHO, *ANYTHING* on a RAID 0 array. I'm sure that
there are some who feel it's OK in certain situations, but certainly not
here.

The problem is that if either drive fails, YOU LOSE *EVERYTHING*!! It
would be a major disaster if you lose the ldf files for a database. Put
them on a RAID 1 array and sleep at night....

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services