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/defaul...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/defaul...kb;EN-US;224071
See also some additional info in the experts-exchange:
http://www.experts-exchange.com/Dat...ledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Joe
Easiest way is below.
http://www.support.microsoft.com/?id=224071
Moving SQL Server Databases to a New Location with Detach/Attach
Hope this helps
John