|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 9:57 AM
Points: 230,
Visits: 450
|
|
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?
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 9:57 AM
Points: 230,
Visits: 450
|
|
I figured it out
thanks anyway
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
Take a full backup.
Why are you truncating and shrinking the log?
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
