Post reply

SQL server shuts off after Backup...any ideas?

  • July 18, 2011 at 10:03 pm

    #241094

    Hi Guys

    came around with some issue when sql agent taking everyday back up at 12 AM.So when it finish back on sunday sql server goes off and have to start manually.

    So any sugetions why what would be the reason?

    and what are the options to set up sql server gets start automatically ?

    Thanks

  • July 18, 2011 at 11:22 pm

    #1354613

    That is very strange. SQL Server itself would not do this. Are you sure that there is no code that would tell the SQL Server service to stop every Sunday? (Maybe it's a bad script to cleanup hanging transactions).

    Also, do check the error logs - if SQL Server encountered an error, it would be logged in there.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • July 19, 2011 at 1:27 am

    #1354634

    best would be to search / post your sqlserver Errorlog file ( maybe even your sqlagent.out file)

    ( also have a look at the Errorlog.1 and Errorlog.2 files because they contain the info from the previous sqlserver startup until shutdown - same goes for sqlagent.1, ...)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • July 19, 2011 at 2:42 am

    #1354656

    Is the process run nightly and only Sunday failed? If so, like everyone else said, hit the logs and look for the cause. If not, look to the process.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 19, 2011 at 3:08 am

    #1354669

    Thanks Everyone i will check logs and try to find out..

    again thanx a lot

  • July 19, 2011 at 5:03 am

    #1354710

    You might want to look for a shutdown command while you're at it. However unlikely it could explain the issue.

  • July 20, 2011 at 9:23 am

    #1355741

    Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.

  • July 20, 2011 at 9:27 am

    #1355747

    bernard black (7/20/2011)

    Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.

    I don't get it, care to explain my slow(er) mind this fine morning?

  • July 20, 2011 at 9:38 am

    #1355764

    Ninja's_RGR'us (7/20/2011)

    bernard black (7/20/2011)

    Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.

    I don't get it, care to explain my slow(er) mind this fine morning?

    Suggesting that alcohol consumption is related to an accidental shutdown.

  • July 20, 2011 at 9:45 am

    #1355774

    homebrew01 (7/20/2011)

    Ninja's_RGR'us (7/20/2011)

    bernard black (7/20/2011)

    Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.

    I don't get it, care to explain my slow(er) mind this fine morning?

    Suggesting that alcohol consumption is related to an accidental shutdown.

    Thanks. My mind's firing too much from my own QOTD. I need a break! :hehe:

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

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