Loading
Topic
Error 927
1 post about Error 927 by 1 contributor.
Know Error 927? Share what you know with developers who are learning it.
+ Follow Error 927Be the first to follow this
- Articles
- 1
- Contributors
- 1
Articles about Error 927
- Article · SQL Server
Error 927 - Database Cannot Be Opened While Mirroring Configuration - SQL Server
In this article, you will learn about Error 927: database can't be opened , it is middle of the restoration. it comes when we click on start mirroring. Actually this is not an error, this msg tell us that the database, for which you want to configure the mirror, is not fully restored. First Solution: For this we need to restore the latest transaction log backup on mirror server/ mirror node. Then click on start mirroring again at principal node, it will work. Second Solution: If we have restored the full backup and latest log backup as well and still we are getting error 927. then we need to execute below mentioned command as directed: On Mirror Server run this: ALTER DATABASE <Database_Name> SET PARTNER = ‘TCP://<Principal Server>:5022’ On Principal Server run this: ALTER DATABASE <Database_Name> SET PARTNER = ‘TCP://<Mirror Server>:5022’
