none
SQLServer 2012 Web Backup error that SUPENDED KILLED/ROLLBACK problem never disappear RRS feed

  • Question

  • Hi at all,

    I need help about an installation of SQLServer 2012 Web Edition Sp1.

    It's first time that I use Web Edition so tu backup database I developed a .net console application that do Backup with SMO object of SQLServer.

    Sometimes this procedure exit with backup error and all future backup tenative will throw an error exception that sound like other operation lock something and backup can't start.

    I try to Kill process that is SUSPENDED and KILLED/ROLLABACK status, but that process never disappear.

    I try to use Kill with statusonly to get information about rollback completion % but this percentage remain at 16% for a couple of days so I need to power off database server to resolve this issue, but it's a big problem for my production environment.


    I used SQLServer from 2005 with Standard edition and I've never had problem like this.


    Could you help me ?

    Is it a know bug ? Is there a workaround to solve my problem ?



    Thanks for help 
    Friday, September 5, 2014 9:23 AM

Answers

All replies

  • I don't believe this error is specific to the Web Edition of SQL Server. Some of the features are suppressed in non-Enterprise/Developer editions but the core functionality of the SQL database engine remains the same across the editions. It might be something to do with SMO but not the Web edition.

    Satish Kartan http://www.sqlfood.com/

    Friday, September 5, 2014 6:25 PM
  •  will throw an error exception that sound like other operation lock something and backup can't start.


    And which exact error message are you getting? A bit more precise then "sounds like" would be kind and more helpful.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Saturday, September 6, 2014 8:57 AM
    Moderator
  • Hi GruppoSinapsi,

    Based on your description, as Olaf’s post, you can post the error message for analysis.

    In addition, I recommend to check if there is other third party software such as compression tool  blocking the Kill process to complete. If so, kill the running process of the third party software in Windows Task Manager, then check if you can successfully kill process in SQL Server.

    For more details, please review the following similar blog:
    SQL Backup Process Hanging and Stuck in Kill/Rollback – HyperBac: https://blog.netnerds.net/2010/05/sql-backup-process-hanging-and-stuck-in-killrollback-hyperbac/


    Thanks,
    Lydia Zhang


    Tuesday, September 9, 2014 3:48 AM
    Moderator
  • Hi GruppoSinapsi,

    I’m writing to follow up with you on this post. Was the problem resolved after performing our action plan steps? If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.

    Thanks,
    Lydia Zhang

    Wednesday, September 17, 2014 10:00 AM
    Moderator