SQL backup does not complete with SharePoint 2010 farm backup

Question

I am trying to take a backup of SharePoint 2010 farm having SQL Server 2008 R2 holding the content DBs and other DBs with NMM 3.0.1 and Networker Server 8.1.1. The SQL DB backups will not complete except for rest of the farm backup. Basically the SQL server snapshots are created and completed..but they are not rolled over to the backup medium. It just simply waits for a long time and then times out. Has any one seen this kind of an issue..? and any help will be appreciated. Thanks..

Santhana..

CarlosRojas · Accepted Answer

Hi,

This is the failure:

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 027114 ERROR:SqlServerWriter is stable. The error is VSS_E_WRITERERROR_NONRETRYABLE. The code is: 0x800423f4. Check the application event log for more information.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 026094 ERROR:Storage Services operation CC_storageServicesInterface::executeReplication failed with an error as follows: DoSnapshotSet failed.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 026084 ERROR:Storage Services operation processExecute failed with an error as follows: Storage Services has terminated with an error.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. INFO:Beginning thaw of for anywriter agent.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. INFO:Progress in RunActivityExecute phase is 0 percent.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. INFO:Overall progress is 60 percent.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 024086 WARNING:An error occurred earlier. Checking the state of the VSS Writers and completing the backup with errors

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 027286 ERROR:A VSS_E_OBJECT_NOT_FOUND error occurred while deleting the VSS snapshot set. The error code is: 0x80042308.

49931 12/12/2014 08:54:34 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical RM .. 027114 ERROR:SQL Server 2008 R2:SQLWriter is stable. The error is VSS_E_WRITERERROR_NONRETRYABLE. The code is: 0x800423f4. Check the application event log for more information.

83124 12/12/2014 08:54:38 0 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR info NMM disabling the Automount feature in order to do PS module proceed the import

37959 12/12/2014 08:54:40 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical The group or resource is not in the correct state to perform the requested operation.

.

63335 12/12/2014 08:54:40 5 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR critical NMM backup failed to complete successfully.

102329 12/12/2014 08:54:40 0 0 0 5608 812 0 shpsqlstg01.corp.emc.com nsrsnap_vss_save NSR info createInstanceBackup() failed

Have you checked the Application and system event logs?

Have you ran config checker? Any errors there?

Thank you,

Carlos

crazyrov · Answer

Can you provide the nmm.raw from the client machine ?

Santhana1 · Answer

Yes, that would be fine.. If I am taking SQL backups alone. When, I am taking the entire SharePoint Farm, the SQL DBs are taken backup through VSS method, which I cannot avoid.

crazyrov · Answer

Its is best to use the VDI for backing up the SQL data.

Santhana1 · Answer

Attached...

Santhana1 · Answer

This is a distributed farm and configured it with Wizard.. The error you are refering to is,when we had the SQL VSS writer issue initially (it was not visible due to some DB naming issues, specifically DB names ending with space). It is set right now.. and the writer is visible..

CarlosRojas · Answer

Hi Santhana

Can you please let us know how you configured the client? Did you set all the savesets one by one or just the general saveset for SQL server?

Is this distributed or stand-alone farm?

See bellow the error:

An invalid writer selection -- SqlServerWriter\SHPSQLSTG01\SharePoint_Config -- for APPLICATIONS has been entered as a saveset.

Santhana1 · Answer

you are right.. the SQL VSS writer though found to be stable, when running the command "vssadmin list writers" is actually pbroken internally (i think), I have restarted the SQL VSS writer services and kick started a Single DB backup which ran fine importing the snapshots properly. Now, I am trying to run the whole DBs list that are required as part of SharePoint farm backup. I run the farm backup.. I will share the result with you.. in some time..

Thanks for the guidance in this so far....really appreciate....

Santhana1 · Answer

Just to update you...NMM took backup of the all the DBs of the Share Point farm, thought it took long time to complete.. there were no errors found..

It is taking lot of time to start rolling over the snapshots ( 3 hours) + 1:30 to actually roll over the data.. Otherwise the backups are running fine....

Sadhbh1 · Answer

Hi Santhana,

Did you just restart the SQL Server VSS Writer?

I am having the same issue, I have restarted the SQL VSS Writer but backups still fail.

Also how do you truncate the SQL logs when doing VSS backups using the NMM.

I am new to NetWorker so any help would be appreciated.

S

NetWorker

SQL backup does not complete with SharePoint 2010 farm backup

Was this post helpful?