Jump to content


sccmkbk

SCCM Backup issue, backup failing with msg "Asynchronous QueryStatus failed or did not finish properly. Error code = 0x80,042,306"

By sccmkbk, in backup and restore

Recommended Posts

sccmkbk

sccmkbk 0

Posted
Posted

Hello

 

Can Some please help me to resolve the SCCM backup failure issue. SCCM backup on my central server is frequently failing with followig error.

"Asynchronous QueryStatus failed or did not finish properly. Error code = 0x80,042,306".

 

Here I am copying the smsbkup.log :

 

Initializing the status message reporting system... SMS_SITE_BACKUP 04/05/2012 01:00:14 18324 (0x4794)

The path to the "Status Manager" inbox is "D:\SMS\inboxes\statmgr.box\statmsgs". SMS_SITE_BACKUP 04/05/2012 01:00:14 18324 (0x4794)

SMS_STATUS_MANAGER is not running as part of this process, the SMS_EXECUTIVE to SMS_STATUS_MANAGER in-memory status message queue will not be used. SMS_SITE_BACKUP 04/05/2012 01:00:14 18324 (0x4794)

Registered this process as a source of "SMS Server" events. SMS_SITE_BACKUP 04/05/2012 01:00:14 18324 (0x4794)

Registered this process as a source of "SMS Client" events. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Registered this process as a source of "SMS Provider" events. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Status message reporting system initialized successfully. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Locale set to OS value (English_United States.1252). SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

SMS site backup service 4.00 started. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

STATMSG: ID=500 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=NSTM1807PDS SITE=00H PID=18396 TID=18324 GMTDATE=Fri May 04 05:00:15.218 2012 ISTR0="SMS site backup" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

05/04/12 01:00:15 - starting backup. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

BackupDir = D:\SMS-BACKUP. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Installation RootDir = D:\SMS. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Site SQL Dir = C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Warning: Backup location and the sms data (installation directory) are on the same volume. Sms Backup creates snapshot of the volume using VSS services and then copies the data to the backup location. It is advisable to have the backup location on a different volume (different than the one that has SMS data and SMS database files), so that the writes to the volume is minimal when the volume snapshot is active. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Sql Writer service is running. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

SMS sql data files: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SMSData_00H.MDF, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SMSLog_00H.LDF SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Site Backup Location = D:\SMS-BACKUP SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

SQL Backup Location = D:\SMS-BACKUP SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

STATMSG: ID=5055 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=NSTM1807PDS SITE=00H PID=18396 TID=18324 GMTDATE=Fri May 04 05:00:15.265 2012 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879) SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Starting VSS initialization... SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Starting Asynchronous GatherWriterMetadata. SMS_SITE_BACKUP 04/05/2012 01:00:15 18324 (0x4794)

Number of writers that responded: 11. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Reading SMS Writer metadata... SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Number of FileIncludes: 0. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Number of FileExcludes: 0. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Number of Components: 7. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 0 - 00HBackup\SiteServer\SMSServer\inboxes. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 1 - 00HBackup\SiteServer\SMSServer\Logs. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 2 - 00HBackup\SiteServer\SMSServer\data. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\DATA\* [Recursive: yes] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 3 - 00HBackup\SiteServer\SMSServer\srvacct. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 4 - 00HBackup\SiteServer\SMSbkSiteRegNAL.dat. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\BackupTemp\SMSbkSiteRegNAL.dat [Recursive: no] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 5 - 00HBackup\SiteServer\SMSbkSiteRegSMS.dat. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\SMS\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Component 6 - 00HBackup\SiteDBServer\SMSbkSQLDBsite.dat. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Dependency On SQL Writer , LogicalPath:NSTM1807PDS, ComponentName:SMS SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

SQL Server is on the same box as the Site Server. So, no need to communicate to the SQL backup agent. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\MSSQL.1\MSSQL\DATASMS.mdf [Recursive: no] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

FileGroupFile = D:\MSSQL.1\MSSQL\DATASMS_log.LDF [Recursive: no] SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

After GatherWriterMetadata SQL Writer status = STABLE. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

After GatherWriterMetadata SMS Writer status = STABLE. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Starting to clean and prepare the backup location. SMS_SITE_BACKUP 04/05/2012 01:00:17 18324 (0x4794)

Cleanup and/or preparation done. SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Starting to create the snapshot set. SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Added volume containing D:\ to the snapshot set. SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

After PrepareForBackup SQL Writer status = STABLE. SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

After PrepareForBackup SMS Writer status = STABLE. SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Info: Starting Asynchronous DoSnapshotSet... SMS_SITE_BACKUP 04/05/2012 01:00:24 18324 (0x4794)

Asynchronous QueryStatus failed or did not finish properly. Error code = 0x80,042,306 SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

Error: CreateSnapshotSet failed... SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

STATMSG: ID=5047 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=NSTM1807PDS SITE=00H PID=18396 TID=18324 GMTDATE=Fri May 04 05:01:31.044 2012 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

SMS site backup service is stopping. SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

STATMSG: ID=502 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=NSTM1807PDS SITE=00H PID=18396 TID=18324 GMTDATE=Fri May 04 05:01:31.450 2012 ISTR0="SMS site backup" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

SMS site backup service stopped. SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

STATMSG: ID=501 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=NSTM1807PDS SITE=00H PID=18396 TID=18324 GMTDATE=Fri May 04 05:01:31.450 2012 ISTR0="SMS site backup" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 04/05/2012 01:01:31 18324 (0x4794)

Share this post

Link to post
Share on other sites
Sana

Sana 0

Posted
Posted

This will help.

 

Run Vssadmi list writers on the srver and see which ones failed.

In my case Sql server writer and sms writer failed. I had to update the logon account details for sql server writer from system account to admin account nd restart the service.

 

Also changed the backup schedule.

 

This worked for me.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Go to topic listing
×
×
  • Create New...