Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Full backup doesn't seem to be working anymore SF_ReplicateAll however Refresh

I created a Weekly backup using SF_ReplicateAll'SALESFORCE' Job on Sunday that doesn't seem to work, however I am running an hourly refresh during the week that works every time.

The log error I am getting is
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
09/28/2014 21:00:00,Salesforce Weekly Backup,Error,,COR-MTL-DB1,Salesforce Weekly Backup,,,The job failed. The Job was invoked by Schedule 11 (Weekly On Sunday). The last step to run was step 1 (Full Backup). NOTE: Failed to notify 'IT' via email.,03:15:04,0,0,,,,0
09/28/2014 21:00:00,Salesforce Weekly Backup,Error,1,COR-MTL-DB1,Salesforce Weekly Backup,Full Backup,,Executed as user: NT SERVICE\SQLSERVERAGENT. ...arting SF_Replicate for AFQ31__THKS_BundledProducts__Tag [SQLSTATE 01000] (Message 0) 21:00:09: Drop AFQ31__THKS_BundledProducts__Tag_Previous if it exists. [SQLSTATE 01000] (Message 0) 21:00:09: Create AFQ31__THKS_BundledProducts__Tag_Previous with new structure. [SQLSTATE 01000] (Message 0) 21:00:09: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 21:00:09: DBAmp Bulk Operations. V2.18.9 (c) Copyright 2006-2014 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 21:00:09: Populating local table AFQ31__THKS_BundledProducts__Tag_Previous COR-MTL-DB1 / salesforce backups . [SQLSTATE 01000] (Message 0) 21:00:10: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 21:00:10: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 21:00:11: 0 rows copied. [SQLSTATE 01000] (Message 0) 21:00:11: Drop AFQ31__THKS_BundledProducts__Tag if it exists. [SQLSTATE 01000] (Message 0) 21:00:11: Rename previous table from AFQ31__THKS_BundledProducts__Tag_Previous to AFQ31__THKS_BundledProducts__Tag [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 21:00:11: Create primary key on AFQ31__THKS_BundledProducts__Tag [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for AFQ31__THKS_BundledProducts__c [SQLSTATE 01000] (Message 0) 21:00:11: Drop AFQ31__THKS_BundledProducts__c_Previous if it exists. [SQLSTATE 01000] (Message 0) 21:00:11: Create AFQ31__THKS_BundledProducts__c_Previous with new structure. [SQLSTATE 01000] (Message 0) 21:00:11: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 21:00:11: DBAmp Bulk Operations. V2.18.9 (c) Copyright 2006-2014 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 21:00:11: Populating local table AFQ31__THKS_BundledProducts__c_Previous COR-MTL-DB1 / salesforce backups . [SQLSTATE 01000] (Message 0) 21:00:11: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 21:00:11: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 21:00:12: 3 rows copied. [SQLSTATE 01000] (Message 0) 21:00:12: Drop AFQ31__THKS_BundledProducts__c if it exists. [SQLSTATE 01000] (Message 0) 21:00:12: Rename previous table from AFQ31__THKS_BundledProducts__c_Previous to AFQ31__THKS_BundledProducts__c [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 21:00:12: Create primary key on AFQ31__THKS_BundledProducts__c [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for AFQ31__THKS_IncludeExcludeServices__Tag [SQLSTATE 01000] (Message 0) 21:00:12: Drop AFQ31__THKS_IncludeExcludeServices__Tag_Previous if it exists. [SQLSTATE 01000] (Message 0) 21:00:12: Create AFQ31__THKS_IncludeExcludeServices__Tag_Previous with new structure. [SQLSTATE 01000] (Message 0) 21:00:12: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 21:00:12: DBAmp Bulk Operations. V2.18.9 (c) Copyright 2006-2014 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 21:00:12: Populating local table AFQ31__THKS_IncludeExcludeServices__Tag_Previous COR-MTL-DB1 / salesforce backups . [SQLSTATE 01000] (Message 0) 21:00:12: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 21:00:12: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 21:00:13: 0 rows copied. [SQLSTATE 01000] (Message 0) 21:00:13: Drop AFQ31__THKS_IncludeExcludeServices__Tag if it exists. [SQLSTATE 01000] (Message 0) 21:00:13: Rename previous table from AFQ31__THKS_IncludeExcludeServices__Tag_Previous to AFQ31__THKS_IncludeExcludeServices__Tag [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 21:00:13: Cr... The step failed.,03:15:04,16,50000,,,,0

Any thoughts?
1 person likes
this idea
+1
Reply