FULL DB backup job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » FULL DB backup job

FULL DB backup job

Rate Topic

Display Mode

Topic Options

Author

Message

nihal9200_kwada

Posted Monday, December 31, 2012 8:12 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:30 PM
Points: 352, Visits: 1,692

Hi,

Full backup job is failing with below error in our production.
this is a LITESPEED full backup for Sys and User DB. Any one has idea on this error? thanks.

Executed as user: xyz\xyz. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:00 AM Progress: 2012-12-31 03:00:01.38 Source: {DFBE0DBF-27DE-4F37-A580-A486C84FB622} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete End Progress Error: 2012-12-26 03:00:09.54 Code: 0xC0024104 Source: Back Up SysDB Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:00:00 AM Finished: 3:00:09 AM Elapsed: 9.062 seconds. The package execution failed. The step failed.

Post #1401401

John Mitchell-245523

Posted Monday, December 31, 2012 8:17 AM

SSCarpal Tunnel

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

Is there anything in the errorlog at the same time as this error?

John

Post #1401403

Lynn Pettis

Posted Monday, December 31, 2012 8:52 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:37 PM
Points: 21,627, Visits: 27,480

Have you checked on the Quest site for information regarding the error? You might find more information there.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1401408

nihal9200_kwada

Posted Monday, December 31, 2012 9:12 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:30 PM
Points: 352, Visits: 1,692

i found the issue. MSDB data file has 0 growth remaining. It's weird that i see this error now, not time of backup job failure.

the drive has no space, so i want to add new file on different large drive.

question is- is it possible to add new file/filegroup system db msdb, if yes is it same process like adding to user db or different? please let me know.

Post #1401413

george sibbald

Posted Monday, December 31, 2012 9:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 5,270, Visits: 11,212

is the msdb large? I would first of all look to see if any data can be purged from it, in particular backup\restore history, job history, SSIS information, those are the usual culprits.

---------------------------------------------------------------------

Post #1401416

nihal9200_kwada

Posted Monday, December 31, 2012 10:35 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:30 PM
Points: 352, Visits: 1,692

yes. purged the backup history and resolved the issue. Thanks.

Post #1401439

« Prev Topic | Next Topic »

Permissions