Post reply

tlog backup job

  • July 2, 2012 at 7:46 pm

    #271933

    Tlog backup job failed with below message. is this something issue with space ? thanks.

    Message

    Executed as user: DOMAIN\z_serversqlservice. ... for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:45:01 PM Progress: 2012-07-02 19:45:04.78 Source: {aaaaaaaaa} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2012-07-02 19:45:08.39 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [LiteSpeedLocal] TO DISK = N'M:\BACKUP...".: 50% complete End Progress Progress: 2012-07-02 19:45:08.45 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Error: 2012-07-02 19:45:28.61 Code: 0xC002F210 Source: Back Up Database (Transaction Log) Execute SQL Task Description: Executing the query "BACKUP LOG [database] TO DISK = N'M:\BACKUP\DAILY..." failed with the following error: "Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Progress: 2012-07-02 19:45:28.67 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [xyzin_p01] TO DISK = N'M:\BACKUP\DAILY...".: 50% complete End Progress Progress: 2012-07-02 19:45:28.74 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:28.83 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [databse] TO DISK = N'M:\BACKUP\DAILY...".: 50% complete End Progress Progress: 2012-07-02 19:45:28.89 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:28.94 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [IRS_DAT_COMET_UAT] TO DISK = N'M:\BAC...".: 50% complete End Progress Progress: 2012-07-02 19:45:28.97 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:29.03 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [database] TO DISK = N'M:\BAC...".: 50% complete End Progress Progress: 2012-07-02 19:45:29.08 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:29.19 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [database] TO DISK = N'M:\BACK...".: 50% complete End Progress Progress: 2012-07-02 19:45:29.25 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:29.33 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [database] TO DISK = N'M:\BAC...".: 50% complete End Progress Progress: 2012-07-02 19:45:29.38 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-07-02 19:45:29.49 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [database] TO DISK = N'M:\BACKUP\DAILY...".: 50% complete End Progress Progress: 2012-07-02 19:45:29.53 Source: Back Up Database (Transaction Log) Executing query "declare @bac... The package execution fa... The step failed.

  • July 2, 2012 at 7:53 pm

    #1507993

    Can you show us the exact Job details/commands?


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • July 2, 2012 at 8:08 pm

    #1507996

    Why do you think it's a space issue? Has it been successful in the past?

    Are you using standard maintenance plan built by SQL Server?

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • July 2, 2012 at 8:33 pm

    #1508001

    Have you checked the SQL Error logs?

  • July 3, 2012 at 2:12 am

    #1508052

    "Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. BACKUP LOG is terminating abnormally.".

    Looks like something is altering the transaction log at the time the TX backup ran.

Viewing 5 posts - 1 through 4 (of 4 total)

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