Hi, I was trying to do a database mirroring( for learning purposes). But the mirroring process failed. I am currently having sql server 2005 developer edition, installed in physically two different machines. It gives me an error that there is some error : with the network address I have specified. Note: I have created these settings through SSMS. The network address is as TCP://<machine>:5022 for both the mirror and principal. Also, if possible can some one please help me restore the mirrored database in the previous state: I mean: I had to restore it with the current back up with recovery on. It is still in Restoring state I hope You get my point. Please reply as soon as possible.
Hi, you can use restore database <yrdbname> with recovery . Can you post the detailed error message you are getting!!
You need to get hold of DB mirroring concepts, please note that mirror database must be in NORECOVERY mode in order to sync the transactions from PRINCIPAL server. Recently I have blogged about TCP/network related settings in this case see http://sqlserver-qa.net/blogs/ha/ar...th-tcp-port-numbers-firewall-involvement.aspx post and this http://sqlserver-qa.net/blogs/ha/ar...rational-microsoft-sql-server-error-1418.aspx one may also help.