Solved

Differential backup job failed.

Posted on 2009-03-30
1
699 Views
Last Modified: 2013-12-01
Hi,
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?

0
Comment
Question by:Techno-Man-uk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
comnuts earned 500 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.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

738 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