Alejandro Santana - Monday, March 12, 2018 10:18 AM
You should test restoring any database (user or system) that you care about the backup of. If you don't test restore a backup, how do you know for certain that it is valid?
I do test restores of the system databases to ensure I can restore a system database in the event of DR. They are pretty small and thus restores of them are quick.
I think the the only database I don't backup and restore is tempdb.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.