Wednesday, March 7, 2012

Moving Primary Transaction log

After installing SQL server 2000 STD, SP3 how can I move primary transaction
log to another drive?
ThanksBACKUP and RESTORE WITH MOVE
or the quicker method:
sp_detach_db
copy the file
sp_attach_db
You will be able to find documentation on each of these methods within Books
Online (within the SQL Server program group).
Keith
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:7C5C9BAF-E835-413B-8F57-4581170BF33A@.microsoft.com...
> After installing SQL server 2000 STD, SP3 how can I move primary
transaction
> log to another drive?
> Thanks
>

No comments:

Post a Comment