MS SQL ERROR.

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.
LVL 1
joe_echavarriaDatabase AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aranaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
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_ZCommented:
Has the service account the rights to create directories under U:\MSSQL\Bac... ?
aranaCommented:
:O
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.