UNSOLVED

Sadhbh1

updated

12 years ago

S

Sadhbh1

1 Rookie

•

16 Posts

0

1321

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

  • CarlosRojas

    1 Rookie

    •

    1693 Posts

    545

    2

    Posted January 5th, 2015 10:00

    Hello Declan,

    The log truncation takes place only when running VDI based backups. As you are running a VSS based backup, required to backup the entire SP farm, in this case the logs will NOT be truncated (this is a VSS limitation).

    You should manage the logs management through SQL itself, using different policies available.

    On the other hand you can use NMM to backup only the SP related DB's using VSS based backups, and then VDI backups to backup any other SQL DB, in case the SQL server hosts also non-SP related DB's.

    Please let us know if you need any further information.

    Thank you,

    Carlos

  • Sadhbh1

    1 Rookie

    •

    16 Posts

    545

    0

    Posted January 5th, 2015 23:00

    Hi Carlos, thanks for your reply.

    So what is the recommended process for using the NMM to backup sharepoint?

    from what I am reading the NMM only  does part of the job.

    If anyone else reading this backing up sharepoint with Networker I would be very interested to know how you are doing it and how you have configured the clients.

    Thanks again Carlos for your replay .

    S