Backup & Recovery

 View Only
  • 1.  Quiesced vCenter Snapshots freeze MS-SQL server

    Posted May 03, 2016 01:20 PM

    We're battling an issue with a virtual SQL server and vCenter sync'd snapshots from our storage array.  We're not having snapshot failures, but the snap is causing just a bit of disruption so that some of our apps are timing out with VSS snap creation.  We don't have the problem when using Veeam's application consistent snaps so I think there must be something else wrong on my guest OS.  I know I can disable unnecessary VSS writers, but I'm a bit unsure which ones it would be safe to disable and still get the consistent snaps in Nimble.

    Here is what we have on our list of enabled VSS writers.  There is a way to disable them using this article: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1031200

    vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool

    (C) Copyright 2001-2005 Microsoft Corp.

    Writer name: 'Task Scheduler Writer'

       Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}

       Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}

       State: [1] Stable

       Last error: No error

    Writer name: 'VSS Metadata Store Writer'

       Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}

       Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}

       State: [1] Stable

       Last error: No error

    Writer name: 'Performance Counters Writer'

       Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}

       Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}

       State: [1] Stable

       Last error: No error

    Writer name: 'System Writer'

       Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}

       Writer Instance Id: {27c00a72-3215-48b6-a699-7bd01b674fa8}

       State: [1] Stable

       Last error: No error

    Writer name: 'SqlServerWriter'

       Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}

       Writer Instance Id: {c7c46f7d-8a70-4530-9445-30a5a80d7fd2}

       State: [1] Stable

       Last error: No error

    Writer name: 'ASR Writer'

       Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}

       Writer Instance Id: {c29e355b-c672-4ef3-8d34-7e75407e96ae}

       State: [1] Stable

       Last error: No error

    Writer name: 'Shadow Copy Optimization Writer'

       Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}

       Writer Instance Id: {0048c718-52fd-416e-bdcc-fc6efac7c369}

       State: [1] Stable

       Last error: No error

    Writer name: 'Registry Writer'

       Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}

       Writer Instance Id: {2c79e02d-8724-469f-8bb8-280e73a21a89}

       State: [1] Stable

       Last error: No error

    Writer name: 'BITS Writer'

       Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0}

       Writer Instance Id: {abc3b9c3-61f6-4de9-a4de-873133b6c8d9}

       State: [1] Stable

       Last error: No error

    Writer name: 'COM+ REGDB Writer'

       Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}

       Writer Instance Id: {f0908cd6-c87c-4dc3-9bb1-2d4b7862e538}

       State: [1] Stable

       Last error: No error

    Writer name: 'WMI Writer'

       Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}

       Writer Instance Id: {b8fc017d-7c54-439d-a612-e70e80bb98f7}

       State: [1] Stable

       Last error: No error

    Which of these are necessary in order to get a quiesced snap in VMware?



  • 2.  RE: Quiesced vCenter Snapshots freeze MS-SQL server

    Posted Oct 25, 2017 09:56 AM

    Hello,

    Go similar issue.When make snapshot on MS SQL server (which is synchronized to another one) during snapshot it cause fail synchornization between servers with semaphore timeout