> We have a report in our system that is pulled many times each week, but > needs to be based off data from Sunday at noon. So every Sunday at noon, we > back up our main database and restore it into a new reporting snapshot > database.
Setup a slave.
Not bad, but the transaction logs would fill up the file system. Besides, it would not be worth it to set up a whole database cluster just for this purpose.
Any alternatives?
--
Moshe Jacobson Nead Werx, Inc. | Manager of Systems Engineering