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!!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
>--Original Message--
>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=djq&as_ugroup=microsoft.public.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
>
> >--Original Message--
> >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!!
> >.
> >|||hi,
1. sp_helpdb pubs , will show u the existing file path
of .mdf and .ldf files.
output:
C:\database\Pubs.mdf
C:\database\Pubs_log.ldf
2. sp_detach_db 'pubs','false'
will detach the database and run UPDATE STATISTICS on all
the tables before detaching.
once detached ,copy the .ldf file to the desired location.
Assuming that u r moving pubs_log.ldf to D drive, execute
point 3.
3. EXEC sp_attach_db @.dbname = 'pubs',
@.filename1 = 'C:\Database\pubs.mdf',
@.filename2 = 'D:\Database\pubs_log.ldf'
4. You can execute Point 1 to see the new path. You may
also delete the .ldf file from the old location.
HTH
Regards
Thirumal
>--Original Message--
>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
>
>>--Original Message--
>>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!!
>>.
>.
>|||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...
>> 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
>>
>> >--Original Message--
>> >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!!
>> >.
>> >
>
>.
>