Backup probleme with SQl Server Writer - folder offline

  • Hi,

    I use a tool to backup mysq MSSQL database with Writer SQL SERVER VSS.

    A database for a database not work because it's excluded from VSS Writer...

    Here the log of SQL Server Writer :

    [08/17/2022 16:21:58, TID 17d8] Skipping database SYNCHRONIZOR on instance SRV-SQLSERVER because file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR is offline.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR.mdf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\LOGS\log\SYNCHRONIZOR_log.ldf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\ftrow_SYNCHRONIZOR.ndf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA2\data\Synchronizor_02.ndf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA3\data\Synchronizor_03.ndf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA4\data\Synchronizor_04.ndf from database SYNCHRONIZOR metadata on instance SRV-SQLSERVER.
    [08/17/2022 16:21:58, TID 17d8] Excluding file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR from database SYNCHRONIZOR metadata on

     

    Here the content of the folder [C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR ]:

     

    PS C:\Windows\system32> cd C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR
    PS C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR> dir


    Directory: C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR


    Mode LastWriteTime Length Name
    ---- ------------- ------ ----
    d----- 17/08/2022 17:07 MssearchCatalogDir
    -a---- 17/08/2022 17:07 960 CatalogStatus.dat
    -a---- 17/08/2022 17:07 188 CatalogStatus.idx
    -a---- 17/08/2022 17:07 40 ftcatstate
    -a---- 17/08/2022 17:07 325 SQL.HDR


    PS C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR> cd MssearchCatalogDir
    PS C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR\MssearchCatalogDir> dir


    Directory: C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR\MssearchCatalogDir


    Mode LastWriteTime Length Name
    ---- ------------- ------ ----
    -a---- 17/08/2022 17:07 286720 00010001.ci
    -a---- 17/08/2022 17:07 4096 00010001.dir
    -a---- 17/08/2022 17:07 65536 00010001.wid
    -a---- 17/08/2022 17:07 249856 00010002.ci
    -a---- 17/08/2022 17:07 4096 00010002.dir
    -a---- 17/08/2022 17:07 65536 00010002.wid
    -a---- 17/08/2022 17:07 4096 00010003.ci
    -a---- 17/08/2022 17:07 4096 00010003.dir

    Do you have an idea please ?

    Thanks for your help,

    Matt

    • This topic was modified 1 month, 2 weeks ago by  mcoussi.
  • Ask the vendor of the tool for help?

    Is the database "offline" or the folder "" offline?

    Have you tried fiddling with the folder permissions ( perhaps the tool, sql server, your account) doesn't have access

  • Hi,

    Thanks for your reply.

    Then vendor says that it's a Microsoft problem so i have to contact Microsoft .... So you understand that i am alone ..

    An other information : The database is member of AAG Group.

    Backup on primary database is OK. The problem is on the Replica.

    I have compared the permission on each server (Primary and Replica) - the same.

    Matt

  • I'm not familiar with AAG groups or replica's.

    As you're working with AAG's you might get funding for a MS support call / consultant to sort it out

  • mcoussi wrote:

    Then vendor says that it's a Microsoft problem so i have to contact Microsoft .... So you understand that i am alone ..

    Lordy.  I'd be interested in knowing the name of such an arrogant vendor that won't even help a paying customer identify what the issue is so that you could ask MS about it.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • This was removed by the editor as SPAM

  • Hi,

    The database was only used by one request.

    Dev Team has migrated the data in an other database.

    The database was put OFFLINE and get out of AAG.

    Thanks all for your help,

    Matt

  • This was removed by the editor as SPAM

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply