Post reply

Problem in the differential backup

  • November 26, 2014 at 4:35 am

    #312801

    Hello,

    I have problem in differential backup. The following strategy was adopted:

    1 - FULL DAILY

    2 - DIFFERENTIAL A DAY AT A TIME

    3 - LOG EVERY TIME 1

    Backup was created by manuntenção plan, the full log and works perfectly.

    The following error is generated:

    Executing the query "BACKUP DATABASE [TESTE] TO DISK = N'E:\\Backup_SQL\\..." failed with the following error: "Não é possível fazer a cópia de segurança diferencial da base de dados "SPED" devido a não existir uma cópia de segurança da base de dados atual. Faça uma cópia de segurança da base de dados completa voltando a emitir BACKUP DATABASE e omitindo a opção WITH DIFFERENTIAL.

    BACKUP DATABASE está a terminar anormalmente.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Tranks.

  • November 26, 2014 at 4:47 am

    #1761043

    Any chance you could translate that error?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 26, 2014 at 5:04 am

    #1761048

    Executing the query "BACKUP DATABASE [TEST] TO DISK = N'E: \\ \\ Backup_SQL ..." failed with the Following error: "Can not make a differential backup of the database" TEST "due to there is no backup of the current database. Do a full database backup returning to issue bACKUP dATABASE and omitting the wITH DIFFERENTIAL option.

    BACKUP DATABASE is terminating abnormally "Possible failure Reasons:. Problems with the query,". ResultSet "property not set Correctly, parameters not set Correctly, or connection not established Correctly

  • November 26, 2014 at 5:07 am

    #1761052

    Are you using some other form of full backup as well? SAN Snapshot? BackupExec? Something else?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 26, 2014 at 9:23 am

    #1761130

    Not, Create maintenance plan only

  • November 26, 2014 at 11:20 am

    #1761155

    Just double-check quickly that your server admin doesn't have something set up.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 26, 2014 at 1:31 pm

    #1761166

    But can be specific.

  • November 27, 2014 at 1:19 am

    #1761213

    cpd 60311 (11/26/2014)

    But can be specific.

    ??

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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