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.