Duran (3/31/2015)
I was going to stop/disable the merge jobs on the distributor, detach the database, move the log file to another drive, reattach, and enable the merge jobs on the distributor.Does that sound ok
No, definitely not, do not detach the database.
Duran (3/31/2015)
or should I employ some other method.Thanks,
Regards,
D.
Use the ALTER DATABASE ... MODIFY FILE
command to move the database file in the system catalogs. Take the database offline and then move the file at the OS level to the new location then bring the database back online.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉