SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Differential Backup failed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ajaykumar401
Starting Member

India
2 Posts

Posted - 08/16/2013 :  05:58:35  Show Profile  Reply with Quote
Hi,

I've scheduled M-Plan to perform Full & Diff. backups, till yesterday those plans were ran fine, but Today Diff. backup job failed with the reason below --

Executing the query "BACKUP DATABASE "" TO DISK = N'..." failed with the following error: "Cannot perform a differential backup for database "", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I already performed Full backup job, but still failing with the same reason...please help me..it is an emergency...

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 08/16/2013 :  08:31:37  Show Profile  Reply with Quote
You are not doing a COPY ONLY backup when you take the full back up are you? If you are, that would explain the problem. You can find if your last full backup was copy only using this:
SELECT TOP ( 1 )
        database_name ,
        is_copy_only ,
        backup_start_date
FROM    msdb.dbo.backupmediafamily bm
        INNER JOIN msdb.dbo.backupset bs ON bm.media_set_id = bs.media_set_id
WHERE   database_name = 'YourDatabaseName'
		AND bs.type = 'D'
ORDER BY backup_start_date DESC
If it was not copy only, then I don't know what else might be causing this problem. Look at all the columns (SELECT *) in the query above and see if any of the fields give you any clue as to what might be wrong.
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
806 Posts

Posted - 08/19/2013 :  14:31:13  Show Profile  Reply with Quote
Are you - at any time after the full backup and before the next scheduled differential backup - switching the recovery model of the database?
Go to Top of Page

ajaykumar401
Starting Member

India
2 Posts

Posted - 08/20/2013 :  04:01:00  Show Profile  Reply with Quote
We are not switching recovery model of any DB...Not sure why Diff. backup job getting failed...
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 08/20/2013 :  10:48:38  Show Profile  Reply with Quote
Did you attempt to run the query I had posted to see if MSDB recognizes that you have full backups?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000