February 6, 2008 at 7:42 am
I know it exists in SQL Server 2005 but I read many articles that it is not working, it that true?
If it is working in SQL Server 2005, after I create the mirror database, can I access the mirror database, that is query the table, running SSIS against it?
Thanks
February 6, 2008 at 7:49 am
Hello Loner,
Yes it is available in SQL 2005 and it is working.
You can't directly query the mirror database but in fact you need to create a snapshot of the mirror database and on that you can query through SSIS as desired.
Hope this helps.
Thanks
Lucky
February 6, 2008 at 7:58 am
Hi Loner,
There's also some restrictions re: what Editions can participate as (witness, partner). Worth looking here for quick reference:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
February 6, 2008 at 8:03 am
mirroring was not supported in the RTM version. You must have at least SP1 to use and it works great, though it has limitations.
The snapshot on mirror works well, but it is a point in time, so changes made to the source database( and mirror) after the snapshot won't show up in the snapshot.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply