Check_Mirroring_Status.ps1

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

  • 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

  • Thanks for the script.

  • 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