
UNSOLVED
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
Responses (0)
Solutions (0)
