We help IT Professionals succeed at work.
Get Started

MS SQL ERROR.

576 Views
Last Modified: 2016-04-26
Hi,

  I have two backups jobs that are failing.  Please tell me to figure it out the solution.

  Error Backup 1 :

Executed as user: FENWAL\svc-sqldoha5601. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:01:05 PM  Error: 2016-04-13 12:24:13.93     Code: 0xC002F210     Source: Back Up Database (Transaction Log) Execute SQL Task     Description: Executing the query "BACKUP LOG [Shipment] TO  DISK = N'U:\MSSQL\Backup..." failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup.  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  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:01:05 PM  Finished: 12:24:14 PM  Elapsed:  1389.3 seconds.  The package execution failed.  The step failed.

  Error Backup 2 :

Executed as user: FENWAL\svc-sqldoha5601. ...0.1600.1 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:46:48 PM  Progress: 2016-04-13 12:46:49.24     Source: {AD7EC283-5D24-4584-9EB5-BF0E0999B816}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2016-04-13 12:46:49.26     Source: Maintenance Cleanup Task      Executing query "EXECUTE master.dbo.xp_delete_file 0,N'U:\MSSQL\Bac...".: 100% complete  End Progress  Progress: 2016-04-13 12:46:51.13     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 1% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 3% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 4% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 6% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 7% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 9% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 10% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 12% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 14% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 15% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 17% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 18% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 20% complete  End Progress  Progress: 2016-04-13 12:46:51.14     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 21% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 23% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 25% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 26% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 28% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_subdir N'U:\MSSQL\Bac...".: 29% complete  End Progress  Progress: 2016-04-13 12:46:51.15     Source: Back Up Database Task      Executing query "EXECUTE master.dbo.xp_create_sub...  The package execution fa...  The step failed.
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE