Post reply

Some backup jobs started to fail after SQL and windows server updates (including sollution)

  • July 12, 2012 at 11:48 pm

    #272324

    Hi all,

    Recently some (not all) scheduled backup jobs failed, reporting the following error:

    "........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: 22:00:00 Finished: 03:07:59 Elapsed: 18349 seconds. The package execution failed. The step failed."

    Just before these backup errors we have applied a lot of fixes to the production server. After doing some google searches we found some similar problems executing jobs.

    Re-registering the following DLL fixed the problem:

    RegSvr32 SQLTaskConnections.dll

  • July 13, 2012 at 5:13 am

    #1512459

    Do you have a question or are you just reporting something you ran across and fixed?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 14, 2012 at 11:16 pm

    #1512849

    The latter one (that's why I posted it as including the solution). I most cases people tend not to write about things solved by themselves. I think that's a waste of knowledge. Searching the internet gives a lot's of results on common problems, but more specific are hard to find, so was this one.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply