Using SQL mirroring in Reporting services

Hi all,
 
    I have SQL 2008 active, passive in my primary DC , Im using double Take high availability software to replicate the data to my single SQL in my disaster recovery site, I need  away to replicate my Primary Database from my active/passive and setup a standalone server that replicates my Database since I want to reduce the DB load from my production server in the primary DC. pls advise
LVL 1
ITMaster1979Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
If you have an enterprise version of SQL, you can take a snapshot against the mirrored database and query it.

Database mirroring or log shipping setup from main to DR server.
(Enterprise version required) to create a snapshot from the database that is in recovery mode on the local sql server.

In the absence of that backing up/restoring the database as part of the reporting might be the only option or creating a read only snapshot using the backup file.
Use login transfer scripts to create the same database logins with the same SIDS on the DR site so that when you restore the DB from backup the same access for the same users that exists on the main server will exist on this one.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.