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' "

By default, RBackup Endpoint performs Differential backups for the SQL Database. To override this behaviour, we can add a registry key "ForceFull" in the registry location below::

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.


 sql (0.88 KB)
(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
Full Name:
Online Backup Software by Remote Backup Systems fusion