Featured post
Reporting Services and SQL Server Mirroring -
in installation 2 sql server 2008 sp2 standard servers use mirror have failover partner databases.
one of purposes of databases supply reports through sql server reporting services.
my question how set have failover of reports , keep cost @ minimum.
i can see 1 solution reporting databases mirrored user databases use. reporting services failover?
another way install 2 separate instances of reporting services on each database server reporting databases not mirrored , both running. how redirect users browsers 1 entry address running reporting service?
there's witness server running sql server 2008 express. upgraded standard , run reporting services (should able failover through native client connection), reporting service self has no failover.
i don't know if i'm missing here impossible in way without using sql server enterprise , failover cluster solution?
any ideas, thoughts , links appreciated, aware have read lot of guides , best practices around internet , haven't found answers question please post relevant links.
any info gather post, links , research , testing of course go stackoverflow future reference others can't imagine i'm 1 such solution.
- smint
you need mirror data , manually repoint report server when data moves mirrored servers.
moving interrelated databases mirroring complicates things. if 1 goes offline reason , failes mirror, other databases fail well?
you may want have human make these decisions , use manual failover on mirroring well.
- Get link
- X
- Other Apps
Comments
Post a Comment