MS SQL ERROR.

joe_echavarria
joe_echavarria used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
for the first one it can happen if you have never create a full database backup and then you want to backup the logs, if you first create a full backup then error should not happen, the other reason is probablu you changed the recover model from full to simple or viceversa, or you can try a differential backup.
 
for the second one, I think there is not enough information to troubleshoot
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
100% with arana.
Perform a FULL backup Shipment database and then the BACKUP LOG job should run without problem.

2nd one can be many things but without a clear error message will be hard to help you.

Btw, those are maintenance tasks created by SQL Server Maintenance Plan?
Docteur_ZDatabase Engineer

Commented:
Has the service account the rights to create directories under U:\MSSQL\Bac... ?
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
joe_echavarria, I unaccepted my comment as solution since I was only supporting arana's comment.
From my point of view you should accept arana's comment as solution and mine as assisted solution.
Cheers

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial