MS SQL Server DTS - SSIS/DTS and SQL 2005 database mirroring.... how?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS/DTS and SQL 2005 database mirroring.... how?

Paul

2006-03-29, 9:29 am

Hi,

We plan to utilise SQLServer 2005 mirroring within the company as we cannot
get budget for proper clustering....

I have a central system on SQL2000, and this will need to DTS data down to
a SQL 2005 system at our co-lo facility. The SQL at the co-lo facility
will be utilising SQL2005 mirroring.

1. Machine SQL02 is the primary, SQL03 the mirror. In the DTS job
(SQL2000), I assume the DTS will be pointed to SQL02, and should a failover
occur, I'll need to set the DTS to point to the new primary server SQL03
manually?

2. How does SSIS act in a mirror setup? What server should it be on? Duped
on each server and enabled/disabled on the failover/mirror as appropriate?

Thanks for any pointers
Paul

Sponsored Links