Wednesday, March 21, 2012

moving sql srvr logs

what is the quickest and safest way to move sql srvr logs
to a different partition in the server.
is there a way to do it using enterprise manager?
thanx team!!Yep. Read KB 224071 for more info.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"dalatingod" <dalatingod@.hotmail.com> wrote in message
news:12ac501c3f6c6$2248a6d0$a001280a@.phx
.gbl...
> I think i found the solution
> detaching the database, then phisically moving the logs
> to a different partition
> and after that re attaching the database
> please confirm that this is correct
> Thanx
>
> logs|||Cheers Tibor
the KB describes it in a lot of detail
many many Thanks!!

>--Original Message--
>Yep. Read KB 224071 for more info.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"dalatingod" <dalatingod@.hotmail.com> wrote in message
> news:12ac501c3f6c6$2248a6d0$a001280a@.phx
.gbl...
>
>.
>

No comments:

Post a Comment