October 24, 2010 at 11:16 pm
Our accountants could benefit from having a copy of our ERP systems database for reporting. Based on the research I've done, I am considering setting up asynchronous mirroring and create snapshots from the mirror.
My question is, how to I automate the snapshots so that the accountants can always have a common database name to connect to without interruption? Obviously I can create a job that creates the new snapshot and drops the previous one but I am wondering what others do and if there are any elegant solutions that I am not aware of.
October 24, 2010 at 11:20 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1009782-1549-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy