I have been tasked to create a second copy of a live database so that we can query the copy instead of the production db. I was researching mirroring, for which I learned that you cannot do anything with the mirror, so I am back to square 1. What method best suits the creation of the above scenario? I just need to know I am on the right path, and then I can setup a test of the solution,
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!