Want to moved the ldf to a different drive but don't want to restart sql server. Is there a way to move it without having to restart sql instance.
You can move files by detach/attach method and this does not need the SQL instance to be restarted. Obviously the database that you are moving will be unavailable during the operation, but that's unavoidable.
19 People are following this question.