Post reply

Maintenance Plans Failing

  • February 9, 2015 at 4:08 am

    #304004

    Hi to all. I have moved our ERP system to a new platform (from Windows 2003/sql 2005 to Windows 2012/SQL 2014). The new server resides in a different domain. I created from scratch identical maintenance plans. Both the database and transaction log jobs are failing. Transaction log example below.

    Date09/02/2015 10:31:11

    LogJob History (Database Plan.Transaction Logs)

    Step ID1

    ServerMYSERVERNAME

    Job NameDatabase Plan.Transaction Logs

    Step NameTransaction Logs

    Duration00:00:03

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: DOMAIN\AccountName. Started: 10:31:11 Finished: 10:31:12 Elapsed: 1.547 seconds. The package execution failed. The step failed.

    Server application logs record events 3041, 12291 and 208.

    Has anyone else come across this?

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • February 9, 2015 at 9:20 am

    #1776405

    Manual backups also fail. A crash dump is created. I stumbled across this thread http://www.sqlservercentral.com/Forums/Topic1588898-3411-2.aspx. My issue appears similar. I am running 2014 RTM (no CU). I have reviewed the CU's and none of them provide a fix for the issue I am facing.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • February 9, 2015 at 9:29 am

    #1776412

    What does a manual backup fail with?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 9, 2015 at 9:32 am

    #1776414

    Hi.

    Backup failed for Server 'SERVER-NAME'. (Microsoft.SqlServer.SmoExtended)

    System.Data.SqlClient.SqlError: BACKUP DATABASE is terminating abnormally. (Microsoft.SqlServer.Smo)

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • February 9, 2015 at 9:34 am

    #1776416

    Err, I meant manual backups, as in BACKUP DATABASE ... TO DISK = ....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 9, 2015 at 9:39 am

    #1776419

    🙂

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • February 9, 2015 at 10:19 am

    #1776438

    A server re-boot appears to have resolved the issue. I am now able to execute backups and maintenance plans appear to run OK.

    Prior to the reboot I noted when running the maintenance plan the directory's would be created in the disk backup target. If I tried to access the directory Windows displayed message stating I needed admin permissions (I am an admin). I ran gpedit.msc on local machine and disabled 'User Account Control: Run all administrators in Admin Approval Mode'. I am not sure if this fixed the issue or the reboot. I will reverse and test.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • February 10, 2015 at 2:13 am

    #1776560

    Weird.

    That's one of the more useless error messages I've seen SQL return too. Nothing more useful in the error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 10, 2015 at 4:08 am

    #1776570

    Hi. I have checked the logs and found the entry below for one of the failures:

    2015-02-09 16:59:17.18 spid69 * BEGIN STACK DUMP:

    2015-02-09 16:59:17.18 spid69 * 02/09/15 16:59:17 spid 15036

    2015-02-09 16:59:17.18 spid69 * Private server build.

    2015-02-09 16:59:17.18 spid69 *

    2015-02-09 16:59:17.18 spid69 *

    2015-02-09 16:59:17.18 spid69 * Exception Address = 00007FF8FCC72D45 Module(sqlmin+00000000009D2D45)

    2015-02-09 16:59:17.18 spid69 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    2015-02-09 16:59:17.18 spid69 * Access Violation occurred reading address 00007FF94B2DCAA0

    2015-02-09 16:59:17.18 spid69 * Input Buffer 134 bytes -

    2015-02-09 16:59:17.18 spid69 * BACKUP DATABASE DB TO DISK = 'C:\temp\DB.Bak'

    There is then a load of stack dump information.

    Thanks for your time, very much appreciated.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

Viewing 9 posts - 1 through 8 (of 8 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy