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.com
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.c om...
> 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.c om...
> on
> own
>
|||Hi
Under limited circumstances:
http://support.microsoft.com/default...b;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...[vbcol=seagreen]
> 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...
drive
>