I have a mirrored database and I would like to create (or use, if they already exist) a set of stored procedures that "Front" the tasks in the Mirror properties dialog - (Pause, resume, failover).
Several questions - do such procs already exist somewhere that I can tap into or will I have to create them myself, assuming that there are T-SQL statements that can be called to perform those actions? Where would they be and/or where should I create them? MSDB? Elsewhere?
Can I create a database user that is NOT the SA user (or dbowner at all for my database) but has authority to perform those operations?
I would like to build into my existing front-end "dashboard" application, the ability to call these functions and perform those operations, but I do not want to have to use SA to get those done.
Any thoughts? Did I pose the question clearly enough?
Thanks in advance for any help!