Re: Need solution for weekly database "snapshot"

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

On Mon, Apr 22, 2013 at 12:14 PM, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote:

> 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

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle