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