Best Practice Backing Up SQL System DBs
What is the best pratice for backing up the four SQL System Databases. Master, Model, MSDB, and TempDB?
Forum Discussion
- Hi, 1. Use the SQL agent as this allows online backups and restores. 2. Turn off Advanced Open File Option as this causes issues when snapshotting the DB. Also read the TN below: https://www.veritas.com/support/en_US/article.000068211 Thanks!
