Start Free TrialLog in
Avatar of joe_echavarria
joe_echavarriaFlag for Dominican Republic

asked on 

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.
Microsoft SQL Server 2008Microsoft SQL Server
Avatar of undefined
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
Avatar of Arana (G.P.)
Arana (G.P.)
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image
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?
Avatar of Docteur_Z
Docteur_Z
Flag of France image
Has the service account the rights to create directories under U:\MSSQL\Bac... ?
Avatar of Arana (G.P.)
Arana (G.P.)
:O
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image
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
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent