UNSOLVED

Sadhbh1

updated

12 years ago

S

Sadhbh1

1 Rookie

16 Posts

0

1315

January 5th, 2015 08:00

ow to Truncate SharePoint SQL transaction Logs?

Hi,

I am trying to backup our SharePoint 2013 Farm using NMM301 and Networker 8.11.

I have four servers in the farm, two front end web servers, one application server and an SQl server, all are windows 2012R2.

The SLQ server has been backing up ok until a few days ago when we discovered that the transaction logs disk is full. The logs have not been truncated when the backups completes.

I have the following error in the client log.

92347:nsrsnap:***************** Snapshot Management operation has started, logging to "E:\Program Files\EMC NetWorker\nsr\logs\nwsnap.raw" *****************01/05/15 16:16:03.615143 [nsr/save/nsrsnap.c 611] Calling nsrrm_host

01/05/15 16:16:03.837193 [nsr/save/nsrsnap.c 886] Calling get_pool_name..

52051:nsrsnap:Printing savecmd=nsrsnap_vss_save.exe after parsing

01/05/15 16:16:06.405460 [nsr/save/nsrsnap.c 1693] Calling snap_wait..

APPLICATIONS:\SqlServerWriter

01/05/15 16:19:41.432041 [nsr/save/nsrsnap.c 1714] Calling parse_fs_logs_and_prefix..

86745:nsrsnap_vss_save:Version information for E:\Program Files\EMC NetWorker\nsr\bin\nsrsnap_vss_save.exe:

Original file name: nsrsnap_vss_save.exe

Version: 3.0.1.2.280

Comments: Supporting Microsoft Volume Shadow Copy Service

102357:nsrsnap_vss_save:Unknown Application Information parameter: NSR_SAVE_FROM_SAVEGRP_NSRSNAP, may not be supported

102357:nsrsnap_vss_save:Unknown Application Information parameter: device interface, may not be supported

102357:nsrsnap_vss_save:Unknown Application Information parameter: NSR_SAVE_FROM_SAVEGRP_NSRSNAP, may not be supported

102345:nsrsnap_vss_save:Data mover host name not specified. Assuming local host: serv8789.europa.internal

102338:nsrsnap_vss_save:Backup is level FULL. Set GLR compatibility to YES.

47363:nsrsnap_vss_save: nsrpsd service is running on serv8789.

82624:nsrsnap_vss_save:Save set name APPLICATIONS:\SqlServerWriter is valid.

63352:nsrsnap_vss_save:NMM .. start the creation of a replica. Replica will be of type Default - which is VSS determined  Non Transportable.

83164:nsrsnap_vss_save:NMM .. An error was detected during the replica creation.  Details in nmm.raw on serv8789 and in the Windows Application or System Event Log.

49931:nsrsnap_vss_save:RM .. 027121 ERROR:SQL Server 2008 R2:SQLWriter has failed at prepare snapshot. The error is VSS_E_WRITERERROR_NONRETRYABLE.  The code is: 0x800423f4. Check the application event log for more information.

49931:nsrsnap_vss_save:RM .. 027121 ERROR:SQL Server 2008 R2:SQLWriter has failed at prepare snapshot. The error is VSS_E_WRITERERROR_NONRETRYABLE.  The code is: 0x800423f4. Check the application event log for more information.

49931:nsrsnap_vss_save:RM .. 027121 ERROR:SQL Server 2008 R2:SQLWriter has failed at prepare snapshot. The error is VSS_E_WRITERERROR_NONRETRYABLE.  The code is: 0x800423f4. Check the application event log for more information.

Microsoft DiskPart version 6.2.9200

Copyright (C) 1999-2012 Microsoft Corporation.

On computer: SERV8789

Automatic mounting of new volumes disabled.

Microsoft DiskPart version 6.2.9200

Copyright (C) 1999-2012 Microsoft Corporation.

On computer: SERV8789

Automatic mounting of new volumes enabled.

37959:nsrsnap_vss_save:The group or resource is not in the correct state to perform the requested operation.

.

63335:nsrsnap_vss_save:NMM backup failed to complete successfully.

Internal error.

102333 1420474777 3 0 0 3244 6908 0 serv8789.europa.internal nsrsnap_vss_save NSR error 21 Exiting with failure. 0

APPLICATIONS:\SqlServerWriter: Backup of [APPLICATIONS:\SqlServerWriter] failed

My question is, how do others manage the SQL logs when backing up the SQL server as part of the SP farm backups?

Are there other steps required which are not outlined in the EMC documentation?

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

Thanks,

S