cancel
Showing results for 
Search instead for 
Did you mean: 

Best Practice Backing Up SQL System DBs

navar_holmes
Level 5

What is the best pratice for backing up the four SQL System Databases.  Master, Model, MSDB, and TempDB?

1 REPLY 1

CraigV
Moderator
Moderator
Partner    VIP    Accredited
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!