Skip to main content

Recovery for MS SQL Server .- Error 87 4110

Thread needs solution

Hi all,

actually i use the acronis recovery for ms sql server but im not able to create a backup from the hole databses.

I tried to create a FULL Backup from the complete Database server with the gui.

Gui worked fine ... it also creates the job .. but when executing i get this errors:

Actually its the complete logfile for the backup ... the errors are in the last lines.I have no idea why it dont want to work.

The manual says Acronis is able to backup the master db. When i dont backup the master db it works fine.

<?xml version="1.0" encoding="UTF-8" ?>
<log uuid="F52F1011-363D-4E7A-8420-A9319BA714A8" product="Acronis Tasks Service" version="1.0" build="172" task="B3F06804-F495-48B5-BC06-70DBFF6F0118" >
    <event id="1" level="2" module="82" code="0" time="1253703760" message="Backup-Task gestartet." >
    </event>
    <event id="2" level="2" module="82" code="0" time="1253703760" message="Argumente erfolgreich erhalten." >
    </event>
    <event id="3" level="2" module="82" code="0" time="1253703760" message="Benachrichtigungsobjekt erstellt." >
    </event>
    <event id="4" level="2" module="82" code="0" time="1253703760" message="Kalenderobjekt erstellt." >
    </event>
    <event id="5" level="2" module="82" code="0" time="1253703760" message="Marke für Startzeit erstellt." >
    </event>
    <event id="6" level="2" module="82" code="0" time="1253703760" message="Task-Browser erstellt." >
    </event>
    <event id="7" level="2" module="82" code="0" time="1253703760" message="Bereite Backup-Operation vor." >
    </event>
    <event id="8" level="2" module="82" code="0" time="1253703761" message="Computer-Browser-Objekt erstellt." >
    </event>
    <event id="9" level="2" module="82" code="0" time="1253703761" message="Backup-Objekt created." >
    </event>
    <event id="10" level="2" module="82" code="0" time="1253703761" message="Strukturiertes Backup-Objekt erstellt." >
    </event>
    <event id="11" level="2" module="82" code="0" time="1253703761" message="Microsoft SQL Archiver gefunden." >
    </event>
    <event id="12" level="2" module="82" code="0" time="1253703761" message="Backup-Speicherort geöffnet." >
    </event>
    <event id="13" level="2" module="82" code="0" time="1253703761" message="Archiv erstellt." >
    </event>
    <event id="14" level="2" module="82" code="0" time="1253703761" message="Strategy name `Wednesday, September 23, 2009 1:02:06 PM` is set." >
    </event>
    <event id="15" level="2" module="82" code="0" time="1253703761" message="Strategy id `B3F06804-F495-48B5-BC06-70DBFF6F0118` is set." >
    </event>
    <event id="16" level="2" module="82" code="0" time="1253703761" message="Komprimierungsoption angewandt." >
        <field name="CompressionLevel" type="TString">
            high
        </field>
    </event>
    <event id="17" level="2" module="82" code="0" time="1253703761" message="Option zum Schutz angewandt." >
        <field name="ProtectionEncryptMethod" type="TLong">
            0
        </field>
    </event>
    <event id="18" level="2" module="82" code="0" time="1253703761" message="Backup-Optionen erfolgreich angewandt." >
    </event>
    <event id="19" level="2" module="82" code="0" time="1253703761" message="Setting backup sources..." >
    </event>
    <event id="20" level="2" module="82" code="0" time="1253703761" message="Backup-Parameter für Element übernehmen. Typ:ServerInstance; Pfad:/Microsoft SQL Server/(lokal).&#32;" >
    </event>
    <event id="21" level="2" module="82" code="0" time="1253703761" message="Setting backup sources..." >
    </event>
    <event id="22" level="2" module="82" code="0" time="1253703761" message="Backup-Parameter für Element übernehmen. Typ:Database; Pfad:/Microsoft SQL Server/(lokal)/master.&#32;" >
    </event>
    <event id="23" level="2" module="82" code="0" time="1253703762" message="Backup-Quelle geöffnet." >
    </event>
    <event id="24" level="2" module="82" code="0" time="1253703762" message="Configuring backup parameters..." >
    </event>
    <event id="25" level="2" module="82" code="0" time="1253703762" message="Backup parameters configured." >
    </event>
    <event id="26" level="2" module="82" code="0" time="1253703762" message="Microsoft SQL Datenbank zum Backup hinzugefügt." >
        <field name="UserName" type="TString">
           
        </field>
        <field name="RollingSnapshotName" type="TString">
           
        </field>
        <field name="MaxRollingSnapshotsCount" type="TEmpty">
           
        </field>
        <field name="IsRollingSnapshotMode" type="TBool">
            false
        </field>
    </event>
    <event id="27" level="2" module="82" code="0" time="1253703762" message="Backup-Parameter für Element übernehmen. Typ:Database; Pfad:/Microsoft SQL Server/(lokal)/model.&#32;" >
    </event>
    <event id="28" level="2" module="82" code="0" time="1253703762" message="Backup-Quelle geöffnet." >
    </event>
    <event id="29" level="2" module="82" code="0" time="1253703762" message="Configuring backup parameters..." >
    </event>
    <event id="30" level="2" module="82" code="0" time="1253703762" message="Backup parameters configured." >
    </event>
    <event id="31" level="2" module="82" code="0" time="1253703762" message="Microsoft SQL Datenbank zum Backup hinzugefügt." >
        <field name="UserName" type="TString">
           
        </field>
        <field name="RollingSnapshotName" type="TString">
           
        </field>
        <field name="MaxRollingSnapshotsCount" type="TEmpty">
           
        </field>
        <field name="IsRollingSnapshotMode" type="TBool">
            false
        </field>
    </event>
    <event id="32" level="2" module="82" code="0" time="1253703762" message="Backup-Parameter für Element übernehmen. Typ:Database; Pfad:/Microsoft SQL Server/(lokal)/msdb.&#32;" >
    </event>
    <event id="33" level="2" module="82" code="0" time="1253703762" message="Backup-Quelle geöffnet." >
    </event>
    <event id="34" level="2" module="82" code="0" time="1253703762" message="Configuring backup parameters..." >
    </event>
    <event id="35" level="2" module="82" code="0" time="1253703762" message="Backup parameters configured." >
    </event>
    <event id="36" level="2" module="82" code="0" time="1253703762" message="Microsoft SQL Datenbank zum Backup hinzugefügt." >
        <field name="UserName" type="TString">
           
        </field>
        <field name="RollingSnapshotName" type="TString">
           
        </field>
        <field name="MaxRollingSnapshotsCount" type="TEmpty">
           
        </field>
        <field name="IsRollingSnapshotMode" type="TBool">
            false
        </field>
    </event>
    <event id="37" level="2" module="82" code="0" time="1253703762" message="Backup-Parameter für Element übernehmen. Typ:Database; Pfad:/Microsoft SQL Server/(lokal)/meine.&#32;" >
    </event>
    <event id="38" level="2" module="82" code="0" time="1253703762" message="Backup-Quelle geöffnet." >
    </event>
    <event id="39" level="2" module="82" code="0" time="1253703762" message="Configuring backup parameters..." >
    </event>
    <event id="40" level="2" module="82" code="0" time="1253703763" message="Backup parameters configured." >
    </event>
    <event id="41" level="2" module="82" code="0" time="1253703763" message="Microsoft SQL Datenbank zum Backup hinzugefügt." >
        <field name="UserName" type="TString">
           
        </field>
        <field name="RollingSnapshotName" type="TString">
           
        </field>
        <field name="MaxRollingSnapshotsCount" type="TEmpty">
           
        </field>
        <field name="IsRollingSnapshotMode" type="TBool">
            false
        </field>
    </event>
    <event id="42" level="2" module="82" code="0" time="1253703763" message="Backup-Sources erfolgreich hinzugefügt." >
    </event>
    <event id="43" level="2" module="82" code="0" time="1253703763" message="Microsoft SQL Instanz zum Backup hinzugefügt." >
    </event>
    <event id="44" level="2" module="82" code="0" time="1253703763" message="Backup-Sources erfolgreich hinzugefügt." >
    </event>
    <event id="45" level="2" module="82" code="0" time="1253703763" message="Backup-Operation gestartet." >
    </event>
    <event id="46" level="2" module="87" code="0" time="1253703763" message="Backup (vollständig) der 'master' Datenbank des '(lokal)' Microsoft SQL Servers war erfolgreich." />
    <event id="47" level="4" module="87" code="4110" time="1253703764" message="Das Backup der Microsoft SQL Datenbank (master.(lokal)) ist fehlgeschlagen." line_tag="0x120B5C319F646E80"/>
        <event id="48" level="4" module="87" code="4106" time="1253703764" message="Der SQL Befehl Backup/Restore ist vor dem VD Transfer fehlgeschlagen." line_tag="0x38930F7709E76268"/>
            <event id="49" level="4" module="87" code="10240" time="1253703764" message="Ausführen des SQL Statement 'BACKUP LOG [master] TO VIRTUAL_DEVICE='759F6F4E5DF94D138592B7F57BA9CC64' WITH NAME = N'759F6F4E5DF94D138592B7F57BA9CC64', BLOCKSIZE = 65536, MAXTRANSFERSIZE = 4194304, BUFFERCOUNT = 32' fehlgeschlagen" line_tag="0xB19B368B2754D254"/>
                <event id="50" level="4" module="87" code="10240" time="1253703764" message="42000 (4212): [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead." line_tag="0xB19B368B2754D255"/>
                    <event id="51" level="4" module="87" code="10240" time="1253703764" message="42000 (3013): [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally." line_tag="0xB19B368B2754D255"/>
    <event id="52" level="4" module="82" code="917515" time="1253703764" message="Backup-Task fehlgeschlagen. Grund: Mitgliederaufruf fehlgeschlagen" >
    </event>
    <event id="53" level="4" module="14" code="79" time="1253703764" message="Fehler beim Ausführen des Bytecodes." line_tag="0xDB42F6A52324F271"/>
        <event id="54" level="4" module="14" code="11" time="1253703764" message="Mitgliederaufruf fehlgeschlagen" line_tag="0x298D61E7C0088C93">
            <field name="token" type="TIdentifier">
                Backup.BackupPlace.CreateArchive.Apply
            </field>
            <event id="55" level="4" module="87" code="4110" time="1253703764" message="Das Backup der Microsoft SQL Datenbank (master.(lokal)) ist fehlgeschlagen." line_tag="0x120B5C319F646E80"/>
                <event id="56" level="4" module="87" code="4106" time="1253703764" message="Der SQL Befehl Backup/Restore ist vor dem VD Transfer fehlgeschlagen." line_tag="0x38930F7709E76268"/>
                    <event id="57" level="4" module="87" code="10240" time="1253703764" message="Ausführen des SQL Statement 'BACKUP LOG [master] TO VIRTUAL_DEVICE='759F6F4E5DF94D138592B7F57BA9CC64' WITH NAME = N'759F6F4E5DF94D138592B7F57BA9CC64', BLOCKSIZE = 65536, MAXTRANSFERSIZE = 4194304, BUFFERCOUNT = 32' fehlgeschlagen" line_tag="0xB19B368B2754D254"/>
                        <event id="58" level="4" module="87" code="10240" time="1253703764" message="42000 (4212): [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead." line_tag="0xB19B368B2754D255"/>
                            <event id="59" level="4" module="87" code="10240" time="1253703764" message="42000 (3013): [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally." line_tag="0xB19B368B2754D255"/>
        </event>

Thanks for hints and friendly regards,

Markus

0 Users found this helpful

Hello Markus,

Thank you for using [[http://www.acronis.com/enterprise/ | Acronis Corporate Products]]

The issue needs a closer investigation, we should try to reproduce it. If it is possible, we need the copy of your database, we will test the software under your environment.

Please create an e-mail request available on this page, under Contact us click on the Start here button and follow the step-by-step guide.

Thank you.