Automation from Infrastructure level

  • What can be automated in terms of infrastructure level in SQL server.

    Can stopping/Starting SQL server can be automated using a script?..

    Regards,
    SQLisAwe5oMe.

  • That is a really broad question. What are you looking at automating?

  • I was asked to automate a lot of our tasks we do normally.

    I deal with a lot of DR activities....like mirroring/Logshipping failover/failback.

    Also stopping and starting SQL services.....I know SQL stops and start when windows server shutdown/start, however, we would like to do it gracefully.

    So, I was wondering if it's possible to automate these using scripts?

    Please share your experience if you do. Thanks.

    Regards,
    SQLisAwe5oMe.

  • Last I knew, if you shutdown your server gracefully then the services shutdown gracefully as well.

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

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