Post reply

Did a trans log dump now my trans log backup isn't working..

  • November 7, 2009 at 3:59 pm

    #217440

    Hi,

    I had to do a translog dump:

    DBCC SHRINKFILE('mxphxx_log001', 1)

    -- BACKUP LOG MSPHXX WITH TRUNCATE_ONLY DBCC SHRINKFILE('mxphxx_log001', 1)

    Now my translog backups are failing with this error:

    Executed as user: PBGOPS\LPB_SSDS_PRD. ....00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:40:01 PM Progress: 2009-11-07 17:40:06.11 Source: {7405DEE1-C269-48B3-89E2-AD28208B59C9} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-11-07 17:40:06.92 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'P:\Program F".: 25% complete End Progress Progress: 2009-11-07 17:40:06.94 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'P:\Program F".: 50% complete End Progress Progress: 2009-11-07 17:40:06.94 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'P:\Program F".: 75% complete End Progress Progress: 2009-11-07 17:40:06.94 Source: Back Up Database (Transaction Lo... The package execution fa... The step failed.

    Help - I don't know how/if i can reset the translog?

  • November 7, 2009 at 5:06 pm

    #1076389

    I figured it out

    thanks anyway

  • November 7, 2009 at 9:26 pm

    #1076410

    Take a full backup.

    Why are you truncating and shrinking the log?

    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 3 posts - 1 through 2 (of 2 total)

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