Hello Friends, I was wondering if you can help me finding a solution....We need to extract data on a daily basis from production database but since this is production we don’t want to use it for this purpose so we thought of setting up Mirroring and creating snapshot and extract it from there but again because of too many transactions going through the database mirroring is not the option since Mirroring is good for low transaction database. We don’t want to use logship since we don’t want to wait for log restore on the secondary server. Now the question is..what are my options to achieve this in SQL? Please help
You cannot possibly expect a forum thread to get you where you need to be. You will absolutely need to get professional help to be able to a) REALLY understand what your needs truly are and b) get the proper option chosen for your particular nuances and needs and c) get it properly implemented, maintained, monitored, etc.
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail