B ack up all s ystem databases before and after each of the following: Create one schedule for master, model, and msdb databases and run a full backup weekly. If you are running backups with the Unitrends Windows agent, follow these recommendations. If you do not use the SIMPLE recovery model, the transaction log continues to grow. If you are running application-aware vProtect backups, change the database recovery model to SIMPLE for proper transaction log truncation.
If you have a VMware environment, see Best practices for protecting VMware virtual machines for a comparison of agent versus agentless SQL backps. You can protect SQL data using the Unitrends Windows agent or, for VMware environments, you can run application-aware vProtect backups. It is important to protect these databases, however unlike a user database that handles real-time customer transactions, it is not necessary to perform backups on an hourly basis. If any system database fails or becomes corrupt, the SQL Instance becomes unavailable. SQL system databases (Master, Msdb, Model, Distribution, ReportServer, and ReportServerTempDB) are essential for all Microsoft SQL Server operations. Unitrends backup recommendations for SQL system databases. Backup recommendations for SQL system databasesīackup recommendations for SQL system databases ISSUE
0 kommentar(er)
