SCCM Backup is getting failed with error SQL Backup did not complete or abort Resolved

Today going to discussed about CM Backup is keep getting failed. As we backup is most important thing in any of the environment which make us safe J

In Today scenario I am going talk about while enable CM Backup application backup keep getting failed.

Smsbkup.log

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:13:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:14:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:15:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:16:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:17:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:18:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:19:28 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:20:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:21:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:22:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:23:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:24:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:25:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:26:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:27:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:28:29 AM       1252 (0x04E4)

Previous SQL backup was not aborted or completed. Sleeping for 60 seconds...              SMS_SITE_BACKUP            11/1/2018 1:29:29 AM       1252 (0x04E4)

 

SQL Backup did not complete or abort. You must wait till the backup is completed or aborted before you can start off another backup.        SMS_SITE_BACKUP              11/1/2018 1:30:29 AM       1252 (0x04E4)

STATMSG: ID=5051 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS= XXXXX.XXXX.XXXXXX SITE=P01 PID=4292 TID=1252 GMTDATE=Thu Nov 01 00:30:29.121 2018 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0    SMS_SITE_BACKUP            11/1/2018 1:30:29 AM          1252 (0x04E4)

Error: Failed to send start message to the SqlBackup. SMS_SITE_BACKUP              11/1/2018 1:30:29 AM       1252 (0x04E4)

SMS_SITE_BACKUP failed. Please see previous errors. SMS_SITE_BACKUP              11/1/2018 1:30:29 AM       1252 (0x04E4) XXXXX.XXXX.XXXXXX XXXXX.XXXX.XXXXXX SITE=P01 PID=4292 TID=1252 GMTDATE=Thu Nov 01 00:30:29.152 2018 ISTR0="Error: Failed to send start message to the SqlBackup." ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0              SMS_SITE_BACKUP            11/1/2018 1:30:29 AM       1252 (0x04E4)

SMS_SITE_BACKUP service is stopping.          SMS_SITE_BACKUP            11/1/2018 1:30:29 AM          1252 (0x04E4)

All Status message error

Site Component Manager could not find an NTFS partition on site system "\\XXXXX.XXXX.XXXXXX" to hold the Configuration Manager Server Components' files.    Possible cause: The site system does not contain an NTFS partition.  Solution: Using the Windows Disk Administrator, create an NTFS partition on the site system, or convert an existing FAT partition to NTFS.    Possible cause: The site system is not exporting the default drive letter shares, such as "\\ XXXXX.XXXX.XXXXXX \C$", "\\ XXXXX.XXXX.XXXXXX \D$", and so on.  Solution: You might have disabled the default drive letter shares for security purposes. Configuration Manager requires these shares. Please re-enable these shares using the Windows Disk Administrator.    Possible cause: The site system is turned off, not connected to the network, or not functioning properly.  Solution: Verify that the site system is turned on, connected to the network, and functioning properly.    Possible cause: Site Component Manager does not have sufficient access rights to remotely administer the site system.  Solution: Verify that the accounts are properly configured to allow the site server to remotely administer the site system.    Possible cause: Network problems are preventing Site Component Manager from properly accessing the site system.  Solution: Investigate and correct any problems on your network.

Normally while running backup service in SQL Server below registry backup path will created and access  While validate on sql server backup path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Components\SMS_SITE_SQL_BACKUP_CM CM Server Host-name

While starting backup service below path is not getting created



 To Fix above issue SQL Server was in secure zone so no network port was open as require to access File backup path.


Action Taken:

Step 1: Validate From SQL Server CM Backup Path. Getting below ERROR

 

Step 2:  By seeing above error found there are Firewall has been block and backup source is not accessible from sql server.  Considering above error. Open network Port: Internet firewalls can prevent browsing and file sharing

Step 3: Once require communication open and start communication restart backup service and start working as normal.

smsbkup.log

CStateMsgReporter::DeliverMessages - Queued message: TT=1401 TIDT=0 TID='EF736CF9-7214-4796-9C85-2549A9056D8D' SID=5035 MUF=0 PCNT=2, P1='P01' P2='2018-11-04 00:02:43.462+00:00' P3='' P4='' P5=''  SMS_SITE_BACKUP              11/4/2018 1:02:43 AM       10772 (0x2A14)

CStateMsgReporter::DeliverMessages - Created state message file: D:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\incoming\vhtowetn.SMX   SMS_SITE_BACKUP              11/4/2018 1:02:43 AM       10772 (0x2A14)

 EF736CF9-7214-4796-9C85-2549A9056D8D              SMS_SITE_BACKUP            11/4/2018 1:02:43 AM       10772 (0x2A14)

AFTERBACKUP.BAT file does not exist at its predefined location SMSBKUP inbox.              SMS_SITE_BACKUP            11/4/2018 1:02:43 AM       10772 (0x2A14)

STATMSG: ID=5042 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=XXXX.XXX.XXX.COM SITE=P01 PID=12276 TID=10772 GMTDATE=Sun Nov 04 00:02:43.489 2018 ISTR0="afterbackup.bat" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  SMS_SITE_BACKUP              11/4/2018 1:02:43 AM       10772 (0x2A14)

Created the backup ini file successfully.         SMS_SITE_BACKUP            11/4/2018 1:02:43 AM          10772 (0x2A14)


All Backup component comes as green.


 

Happy Learning!!!

Thanks & Regards,
Haresh Hirani
Email: hiraniconfigmgr@outlook.com
Follow me: Twitter @hirravi1 
LinkedIn
https://www.linkedin.com/in/hiraniconfigmgr  



0 Comments

    No Comments

Leave a Comment