Backing up default SQL database's
SQL Server does not allow Differential Backup on the default database (Master, Model, MSDB and Temp DB).
SQL Server does not allow us to backup the "Tempdb", which is clearly stated in the backup log file when you try to back it up. See below
Error from the backup log file:
"SQL Server Backup and restore operations are not allowed on database tempdb.Command: BACKUP DATABASE "tempdb" TO DISK='D:\RbackupTemp\SQL Server\tempdb.rbsql' WITH NAME='Full Backup of tempdb' "
Find below the workaround for backing up "Master, Model and MSDB". Download the attached ZIP file to find 4 files to automate the process of forcing FULL backups for the default database "Master, Model and MSDB". For the override not to affect the other database you are trying to backup, create a NEW Backup set only for these DATABSE's and name it as "MASTERDB".
The 2 batch files Pre-MASTERDB.bat and Post-MASTERDB.bat will run at the begining and at the end of the backup respectively and will trigger "After.reg" and "Before.reg" respectively to change the registry value for the registry key "ForceFull".
To apply this workaround:
Close the RBS Endpoint. Stop rbclient.exe and rbackup.exe processes via task manager (If running).
Open the Registry editor and navigate to the following location.
If 32-Bit Server:
HKEY_LOCAL_MACHINE\SOFTWARE\Quantum Tech, Inc.\Remote Backup\Plugins\SQL Server:
If 64 bit server:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432node\Quantum Tech, Inc.\Remote Backup\Plugins\SQL Server:
Now create a new string Value as below:
ForceFull - False
NOTE: Both the key name and value are case sensitive.