469,111 Members | 1,923 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

relocating transaction log

I want to change the location for the transaction log to a differnent disk
Can anyone tell me how i can do this.
Because sql servetr tells me "i can not delete the primary data or log file"
when i try to delete the transaction log.

Many regards
Nico Heiligers
Jul 23 '05 #1
1 1128
You should never delete the a database transaction log.

You can move database files by detaching the database (sp_detach_db), moving
the physical files to the desired locations and then reattaching the files
from the new locations (sp_attach_db).

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Nico Heiligers" <ni**@phimex.nl> wrote in message
news:42***********************@news.euronet.nl...
I want to change the location for the transaction log to a differnent disk
Can anyone tell me how i can do this.
Because sql servetr tells me "i can not delete the primary data or log
file"
when i try to delete the transaction log.

Many regards
Nico Heiligers

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by TZoner | last post: by
3 posts views Thread by Thiko | last post: by
1 post views Thread by Avanish Pandey | last post: by
15 posts views Thread by Zeng | last post: by
1 post views Thread by Matik | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.