The log file for my msdb database is currently 15 GB. I would like to shrink it and possibly move it to a different disk drive to save space.
Is it safe to run a command like this?
backup log msdb with truncate_only
After running that command, I would then shrink the log file by going to Tasks > Shrink > Files > Log.
Are there any risks with running this?
I am also interested in knowing whether it is possible to move this database to a different drive, but I am concerned that I won't be able to do so because this is a system database.
Can anyone help?