Post reply

Check_Mirroring_Status.ps1

  • March 17, 2012 at 4:13 pm

    #254979

    Comments posted to this topic are about the item Check_Mirroring_Status.ps1

  • December 13, 2012 at 5:36 am

    #1568265

    Hi Eric,

    The script is very usefull.i am new to powershell script .Can you please

    share the powershell script to get the sysjobhistory (msdb database) table from lists of server .

    Thanks

    Ajit

  • May 11, 2016 at 6:58 am

    #1878162

    Thanks for the script.

  • August 17, 2016 at 12:12 am

    #1895840

    Hi Eric,

    I am .net developer and new in powershell the script is very good .Can you please

    share the powershell script to get the below Points.

    1.Instance down/services stopped, including cluster resource issues, after reboot/patching

    a.For stand-alone instances, open Configuration Manager and start the stopped service (sql engine or agent) (only send a ticket if the service still does not start)

    b.For clustered resources, open Failover Cluster Manager and start the stopped role/service (only send a ticket if the service/role still does not start)

    2.Mirroring alerts

    a.Check the current status of the mirror connection in sys.database_mirroring (only send a ticket if the principal is still disconnected from the mirror or witness)

    my emailid is arjundhilod@gmail.com

    Thanks

    Arjun Walmiki

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

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