This technical document is about Manual failover in SQL Server
—————————————————————-
To achieve maximum availability we need to configure Mirror Server which requires for Failover in case of Primary server is not available.
When Primary server availability is assured then we again failover back to Primary. We need to perform this activity manually.
To manually fail over database mirroring :
Connect to the principal server instance and, in the Object Explorer pane, click the server name to expand the server tree.
Expand Databases, and select the database to be failed over.
Right-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box.
Click Failover.
A confirmation box appears. The principal server begins by trying to connect to the mirror server by using Windows Authentication. If Windows Authentication does not work, the principal server displays the Connect to Server dialog box. If the mirror server uses SQL Server Authentication, select SQL Server Authentication in the Authentication box. In the Login text box, specify the login account to connect with on the mirror server, and in the Password text box, specify the password for that account.
If failover succeeds, the Database Properties dialog box closes. The mirror database becomes the principal database and the principal database becomes the mirror.
If failover fails, an error message is displayed and the dialog box remains open.
8 thoughts on “SQL Server Manual Failover”
buy carvedilol 6.25mg pill buy amitriptyline for sale amitriptyline 10mg ca
order amoxil 500mg for sale stromectol tablets for humans order stromectol
order generic cialis 40mg levitra sale best ed drugs
glucophage 1000mg pills order glycomet 1000mg generic nolvadex 20mg without prescription
order prednisone 5mg online cheap prednisone cost buy amoxil 1000mg pills
cheap ed drugs pregabalin 150mg without prescription order finasteride 1mg sale
ondansetron 8mg without prescription sulfamethoxazole us bactrim order online
buy isotretinoin 20mg online zithromax 500mg price purchase zithromax online cheap