Moving Transaction Log to a different device

I understand how to move a transaction log to a different physical drive on
the same server but what I would like to do is move the log file to its own
server. Is this possible?
--
Message posted via http://www.sqlmonster.comHi
No. Files must reside on local storage, SAN, or at a push, on a NAS.
The network IO performance will kill any benefit of having the log on a
different server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason Janes via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ea5aa3bd507542be8969e45573be732a@.SQLMonster.com...
> I understand how to move a transaction log to a different physical drive
on
> the same server but what I would like to do is move the log file to its
own
> server. Is this possible?
> --
> Message posted via http://www.sqlmonster.com|||Just to be clear with one exception a NAS is not supported for SQL Server
file placement.
--
Andrew J. Kelly SQL MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23QxGOkeGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> Hi
> No. Files must reside on local storage, SAN, or at a push, on a NAS.
> The network IO performance will kill any benefit of having the log on a
> different server.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jason Janes via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:ea5aa3bd507542be8969e45573be732a@.SQLMonster.com...
>> I understand how to move a transaction log to a different physical drive
> on
>> the same server but what I would like to do is move the log file to its
> own
>> server. Is this possible?
>> --
>> Message posted via http://www.sqlmonster.com
>|||Hi
Under limited circumstances:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
If someone can afford to meet those restrictions, they can afford a SAN.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eU64apeGFHA.2752@.TK2MSFTNGP12.phx.gbl...
> Just to be clear with one exception a NAS is not supported for SQL Server
> file placement.
> --
> Andrew J. Kelly SQL MVP
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23QxGOkeGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > No. Files must reside on local storage, SAN, or at a push, on a NAS.
> >
> > The network IO performance will kill any benefit of having the log on a
> > different server.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@.epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Jason Janes via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> > news:ea5aa3bd507542be8969e45573be732a@.SQLMonster.com...
> >> I understand how to move a transaction log to a different physical
drive
> > on
> >> the same server but what I would like to do is move the log file to its
> > own
> >> server. Is this possible?
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >
> >
>