Solved

Differential backup job failed.

Posted on 2009-03-30
1
673 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
1 Comment
 
LVL 6

Accepted Solution

by:
comnuts earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now