September 21, 2011 at 8:55 am
how to set up mirroring from sql 2005 to sql 2008 ?
what are the precautions to be taken while setup?
September 21, 2011 at 9:36 am
September 21, 2011 at 2:20 pm
Books online (SQL2008R2) "Database Mirroring Overview" states:
Database Mirroring Support
Since SQL Server 2005 Service Pack 1 (SP1), database mirroring partners and witnesses have been supported by Standard and Enterprise Edition. But the partners must use the same edition, and asynchronous database mirroring (high-performance mode) is supported only by Enterprise Edition. Witnesses are also supported by Workgroup Edition and Express Edition.
Also pay attention to the topic "Prerequisites, Restrictions, and Recommendations for Database Mirroring"
Are you planning it for migration only or will this be a solution for longer time ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply