Moving the transaction logs

Hello,
I have a new raid 5 array, that I would like to move the
transaction logs to. Currently the databases and logs
are on the same drive array. Can anyone point me in the
direction of some documentation for this.
ThanksYour best, fastest bet is using the sp_detach_db and sp_attach_db
procedures. The KB article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
provides a great description of the process.
--
--Brian
(Please reply to the newsgroups only.)
"joe" <joe.blair@.lvmhwatchjewerly.com> wrote in message
news:56e101c40070$5046c950$a301280a@.phx.gbl...
> Hello,
> I have a new raid 5 array, that I would like to move the
> transaction logs to. Currently the databases and logs
> are on the same drive array. Can anyone point me in the
> direction of some documentation for this.
> Thanks|||joe wrote:
> Hello,
> I have a new raid 5 array, that I would like to move the
> transaction logs to. Currently the databases and logs
> are on the same drive array. Can anyone point me in the
> direction of some documentation for this.
> Thanks
See this KB article:
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
See also some additional info in the experts-exchange:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20823435.html
BTW, isn't RAID-5 too blown up for transaction log? Transaction log writes
are synchronous and sequential, idelly suited for a much less expensive
RAID-1.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Jo
Easiest way is below
http://www.support.microsoft.com/?id=224071
Moving SQL Server Databases to a New Location with Detach/Attac
Hope this help
John