none
Errore durante il backup RRS feed

  • Domanda

  • Salve a tutti,

    durante il backup di 4 VM in ambiente VMWare basate su Windows Server 2012 R2 (build 9600) e SQL Server 2016 SP2 riceviamo i seguenti errori:

    Log Name:      Application
    Source:        MSSQLSERVER
    Date:          18/07/2020 12:20:25
    Event ID:      3041
    Task Category: Backup
    Level:         Error
    Keywords:      Classic
    User:          SYSTEM
    Computer:      XXXXX
    Description:
    BACKUP failed to complete the command BACKUP DATABASE XXXXXX. Check the backup application log for detailed messages.

    Log Name:      Application
    Source:        SQLWRITER
    Date:          18/07/2020 12:20:25
    Event ID:      24583
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      XXXX
    Description:
    Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
    Error state: 1, Severity: 16
    Source: Microsoft SQL Server Native Client 11.0
    Error message: BACKUP DATABASE is terminating abnormally.
    SQLSTATE: 42000, Native Error: 3201
    Error state: 7, Severity: 16
    Source: Microsoft SQL Server Native Client 11.0
    Error message: Cannot open backup device '{91A1032B-2E9B-4101-9D75-BC033A0E53DB}2549'. Operating system error 0x80070002(The system cannot find the file specified.).

    Log Name:      Application
    Source:        SQLWRITER
    Date:          18/07/2020 12:20:25
    Event ID:      24583
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      XXX
    Description:
    Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
    Error state: 1, Severity: 16
    Source: Microsoft SQL Server Native Client 11.0
    Error message: BACKUP DATABASE is terminating abnormally.
    SQLSTATE: 42000, Native Error: 3201
    Error state: 7, Severity: 16
    Source: Microsoft SQL Server Native Client 11.0
    Error message: Cannot open backup device '{91A1032B-2E9B-4101-9D75-BC033A0E53DB}1189'. Operating system error 0x80070002(The system cannot find the file specified.).

    Log Name:      Application
    Source:        SQLVDI
    Date:          18/07/2020 12:20:26
    Event ID:      1
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      XXX
    Description:
    SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.
    . Process=4488. Thread=9488. Server. Instance=MSSQLSERVER. VD=Global\{91A1032B-2E9B-4101-9D75-BC033A0E53DB}2772_SQLVDIMemoryName_0. 

    Il backup avviene tramite Veeam ma in realtà lo stesso errore lo abbiamo eseguendo la seguente procedura:

    diskshadow 
    set verbose on
    set context volatile
    add volume C: < DISCO DI SISTEMA
    add volume E: < DISCO CON I DB
    writer verify {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
    begin backup
    create

    Abbiamo aumentato di molto i Max Worker Thread e abbiamo impostato, per la durata del test, lo spazio a "illimitato" per le shadow copies.

    Cosa possiamo verificare?


    #!/consulenza/informatica/aziendale init-S di Cerrito Andrea

    lunedì 20 luglio 2020 15:08

Tutte le risposte