Hi all, i have setup Database Mirroing in the following environment: Primary Server - SERVER A (SQL 2005 DEV edition) Mirror Server - SERVER B (SQL 2005 DEV edition) WITNESS SERVER - SERVER B (SQL EXPRESS) I have applied SP1 on all instances. The endpoints are created successfully but i got the following error when starting the mirroring "Alter Fail for database 'MirrorDB' AKTHAR
See thishttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=225424&SiteID=1 helps. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
hello satya, thanks for the link, but it mention to disable the VIA option , it was already disable for me. does not resolve my problem any advice thanks AKTHAR
ok, i got the solution. you will need also to do a restore of the trans Log in Norecovery mode, which i was missing Thanks all AKTHAR
