hi team, need help facing error while data mirroring .
Please check that the settings are correct, especially in the ALTER DATABASE command.
The one you supplied has a typo, so if you copied that from SSMS you may have the solution already:
it has to be
Please also make sure that the system address exists. Normally you would use a fully qualified domain name or IP address to make sure you are connecting to the right partner.
Take a look at [Setting Up Database Mirroring] and make sure you have all pre-requisites setup, then double check spellings etc. It will probably be something really obvious that you just aren't seeing.: http://msdn.microsoft.com/en-us/library/ms190941(SQL.90).aspx
answered Dec 08, 2010 at 04:55 AM