Monday, February 20, 2012

Moving log files

For performance reasonce I want to move the log files on other physical disk
arrays than those with the data files.
Which is the best way to do it? Is it safe to use sp_detach_db & sp_attach_db?
Thanks,
Luca
> Is it safe to use sp_detach_db & sp_attach_db?
Yes, that's how I do it.
Hope this helps.
Dan Guzman
SQL Server MVP
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:823E3EE8-6752-4BE8-9170-6BFF90D9ECF2@.microsoft.com...
> For performance reasonce I want to move the log files on other physical
> disk
> arrays than those with the data files.
> Which is the best way to do it? Is it safe to use sp_detach_db &
> sp_attach_db?
> Thanks,
> Luca
>
>

No comments:

Post a Comment