Need a advise.
I have inherited a 2008R2 server,which has around 50 databases.
The guy who setup this initially has put both the data and log files on the same drive and now I am planning to move the Log files to a dedicated drive.
Is there a way I can do this task for all the databases one time?
Manually moving each file is very time consuming.