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
>
Wednesday, March 7, 2012
Moving Primary Transaction log
Labels:
database,
installing,
log,
microsoft,
moving,
mysql,
oracle,
primary,
server,
sp3,
sql,
std,
transaction,
transactionlog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment