Peter Lin-被動投資紀錄

昨日參考netadmin網站測試SQL Server 2012手動容錯備援實戰TOP 5

要設定啟動鏡像時,發生1418的錯誤

解決方法如下：將SQL Server Service改為網域管理者帳密(原為Network Service)

再來遇到

You are trying to setup a mirroring on a Database called DBNAME

You are getting this error while trying to setup mirroring.
“Neither the partner nor the witness server instance for database “DBNAME” is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)”

解決方法：

https://itprofessors.wordpress.com/2012/09/09/neit...

將鏡像伺服器下SQL Command (ALTER DATABASE “DBNAME” SET PARTNER OFF)

At the Mirror server open Microsoft SQL Managment Studio , and run the command

ALTER DATABASE “DBNAME” SET PARTNER OFF

This will remove the mirroring partnership from the mirror server.

Then run the mirroring wizard again , on the principal server.