Differential backup job failed.

Posted on 2009-03-30
Medium Priority
Last Modified: 2013-12-01
I tried to run the differentail backup today and got this message
Job ended: 30 March 2009 at 16:36:12
Completed status: Failed
Final error: 0xe0000307 - Microsoft SQL Server supports only full backups of the master database. Differential and transaction log backups are not supported.
Consult the Microsoft SQL documentation for more information.
Final error category: Resource Errors

so does this mean i have to do a full backup of SQL even when running a diff backup?

Question by:Techno-Man-uk
1 Comment

Accepted Solution

comnuts earned 1500 total points
ID: 24024657
Only for mater database  you will need to do a full backup. I have created another policy to perform full backup of master dataase while another policy to perform differential backups for other databases.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question