SQL Server Performance Forum – Threads Archive

Error with SP1

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

---

]]>