This entry was posted in Internals, SQLServerPedia Syndication and tagged backup, internals, restore, sql 2000, sql 2005, sql 2008, system databases on Augby PradeepAdiga. Moral of the story is you can only take FULL backup of master database. Master database has to be in Recovered status always. Consider using a location that is not local to the SQL Server - if that is possible - as that reduces the risk of losing the master database in the case where the server becomes unavailable. The code below will back up the database to a local file. But SQL Server does not allow master database to be restored without recovery. The master database can be backed up the exact same way as any other database. It is confirmed that SQL Server is designed to allow only FULL backup of master database.īut why? For differential backups to be applied on a database, the database has to be in NORECOVERY ( Recovering) state.

You can only perform a full backup of the master database. Let us try out the script to take the differential backup of master database. So SQL Server does not allow any other type of backup operation to be performed on master database. Open SSMS and the backup option looks like this. Why not try taking the differential backup of master database instead. “ Is it possible to take the differential backup of master database?”.

Backup master sql