Differential backup failure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Differential backup failure

18 posts, Page 1 of 2

1 2 »»

Differential backup failure

Rate Topic

Display Mode

Topic Options

Author

Message

Lavanyasri

Posted Monday, October 01, 2012 12:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

Hi Team,

I am facing an issue with differential back up . The differential backup is failed only on sunday . we are taking diff backup every 12 hours .only on sunday the diff backup is failed only once .
Except on sunday we are not seeing any issues .........

Thanks ,
lavanya

Post #1366330

GilaMonster

Posted Monday, October 01, 2012 1:13 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 37,739, Visits: 30,015

And the error message the backup gives is....?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1366335

Lavanyasri

Posted Tuesday, October 02, 2012 6:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

hi ,

Error 3041 severity 16 state 1

BACKUP failed to complete the command BACKUP DATABASE database name WITH DIFFERENTIAL. Check the backup application log for detailed messages.

Thanks,
Lavanya

Post #1366979

GilaMonster

Posted Tuesday, October 02, 2012 6:16 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 37,739, Visits: 30,015

Lavanyasri (10/2/2012)

Check the backup application log for detailed messages.

And?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1366980

Lavanyasri

Posted Tuesday, October 02, 2012 6:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

Executed as user: NT AUTHORITY\SYSTEM. ...ercent processed. [SQLSTATE 01000] (Message 3211) 97 percent processed. [SQLSTATE 01000] (Message 3211) Processed 40 pages for database 'BACKUP_xn', file 'BACKUP__xn_Data' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'BACKUP__xN', file 'BACKUP__xn_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE WITH DIFFERENTIAL successfully processed 41 pages in 0.110 seconds (3.048 MB/sec). [SQLSTATE 01000] (Message 3014) 58 percent processed. [SQLSTATE 01000] (Message 3211) 78 percent processed. [SQLSTATE 01000] (Message 3211) 97 percent processed. [SQLSTATE 01000] (Message 3211) Processed 40 pages for database 'BACKUP_xn', file 'BACKUP_xn_Data' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'BACKUP_xN', file 'BACKUP_xR... The step failed.

Post #1366985

John Mitchell-245523

Posted Tuesday, October 02, 2012 6:46 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434, Visits: 7,218

Is this being done as part of a maintenance plan? My guess is that something other than the backup itself is failing - possibly the removal of an old backup file. Is your maintenance plan configured to delete files older than a certain age?

Two things I'd check, therefore:
(1) Run RESTORE VERIFYONLY FROM DISK = '<Path to backup file>'
(2) Does the backup file location contain files that are older than they should be?

Might also be worth doing a test restore from a full backup plus differential to give you full peace of mind.

John

Post #1366992

SQLmountain

Posted Tuesday, October 02, 2012 7:04 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 29, 2013 6:28 AM
Points: 436, Visits: 712

If you are using a maintenance plan, look closely at the t-sql statement(s) it created. The maintenance plan interface does not always display all of the databases being backed up in the job.

Post #1367010

Nadrek

Posted Tuesday, October 02, 2012 7:45 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 20, 2013 12:28 PM
Points: 675, Visits: 2,031

In job step advanced properties, set the output file, and try again. Then use the output file to determine what's going on; the job step history is limited to a near-worthlessly small amount of data for cases like this (as you can see when it cuts off the detailed information and gives the 'the step failed' generic message.

Post #1367040

vliet

Posted Tuesday, October 02, 2012 7:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:34 PM
Points: 47, Visits: 266

Maybe that differential backup on sunday starts before the full backup is finished. I guess you take full backups once a week. Otherwise the differentials will grow steadily and finally become as large as a full backup. The database will stay available for most operations during a backup. But you cannot start any type of backup during any (other or same) type of backup. Which is for obvious reasons if you think about it for a moment ...

Post #1367048

John Mitchell-245523

Posted Tuesday, October 02, 2012 8:00 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434, Visits: 7,218

vliet (10/2/2012)

But you cannot start any type of backup during any (other or same) type of backup.

That's not entirely true. You can run a log backup while the full backup is in progress. You may be right about differentials, though - I don't think I've ever tried it.

John

Post #1367054

« Prev Topic | Next Topic »

18 posts, Page 1 of 2

1 2 »»

Permissions