Showing posts with label logsto. Show all posts
Showing posts with label logsto. Show all posts

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...
>
>.
>