[MS SQL Server] Principal server unexpected shutdown? |
| Principal server unexpected shutdown? Posted: 06 Sep 2013 10:05 PM PDT Hi,Principal server unexpected shutdown and also not available Primary database , in that situation secondary server MIRROR database should be bring online mode for user access as well as application connectivity (mirror configured High Performance mode - version SQL2K8R2) What command should be executed in secondary database server for bring online? Please confirm as below commandOption 1[code="sql"]Use masterGoALTER DATABASE <Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSSGoRESTORE DATABASE <Databasename> WITH RECOVERY[/code]option 2[code="sql"]Use masterGoALTER DATABASE <Databasename> SET PARTNER OFFGORESTORE DATABASE <Databasename> WITH RECOVERY[/code] |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment