We have a business requirement which is to take a snapshot of a SQL database at 4 points during the day, and then mount this SQL to a different server.  Basically all users will point to the replica whilst the administrators can update the main database.

Is it possible to setup 4 jobs that run at 00:00, 06:00, 12:00 and 18:00 which will do this snapshot and mount, and then when the next job comes along it unmounts the replica before mounting the newest replica.

I hope this makes sense?  We were sold the product by a vendor who provided some support to install this, but since then the support to progress anything have fallen on deaf ears, and as such have been left with a product, without training which we are trying to get working.

Thanks in advance!