Hence both the msdb and model databases may need to be recovered in scenarios like database corruption, a rebuild of the master database or after a new server configuration.

If the model database has been modified then it should be backed up. DBAs can modify the model database with whatever settings that are required and when a new user database is created it will reflect the configuration of the model database. The model database is the blue print for creating any new user database for that particular instance of SQL Server.The msdb database contains scheduled jobs, alerts and backup history therefore a proper backup plan should be implemented for the msdb system database.Back up to Dropbox, Google Drive, Box, Amazon S3, OneDrive, & Azure.Before we get started, let's quickly discuss what the msdb and model databases are used for.Back up to FTP servers with first-class FTP, SFTP, & FTPS support.Back up to local folders, network folders, or attached storage devices.Built-in email notifications for backup job successes, failures, and warnings.Simple yet powerful backup job scheduling.Supports full, differential, and transaction log backups.It also offers rich compression, encryption, scheduling, recovery, and notification services - so that you can stop worrying and get back to business. SQL Backup Master provides an easy way to upload your database backups to one (or multiple) cloud storage services. It can also back up databases to an FTP server - or a folder on your local machine, network server, or storage device.īacking up your SQL Server databases to the cloud shouldn't be complicated or expensive. SQL Backup Master backs up your SQL Server databases to any number of popular cloud storage services such as Dropbox, OneDrive, Amazon S3, Microsoft Azure, Box, Google Cloud Storage, Backblaze, Google Drive, and more.

Download and install the software HERE.

Backup sql master