To back up everything, just copy the Microsoft User Data folder to the second
drive, and restore it to that location should it ever become necessary.
Make sure you quit the database daemon before making that copy.
either:
Turn off Œnotifications¹ and quit all office apps
or:
Open Œactivity Monitor¹ application, select ŒMicrosoft database daemon¹ and
hit the Œquit¹ button;
or:
Run tis applescript:
Tell app ³Microsoft Database Daemon² to quit
If you don¹t quit the daemon you may well end up with a corrupted database,
as file buffers may not have been written to the database file before you
take the copy. That could leave portions of the database index in an
indeterminate state.