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.
The problem is that backing up and restoring the database every week
On Mon, Apr 22, 2013 at 11:58:58AM -0400, Moshe Jacobson 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.
On Mon, Apr 22, 2013 at 12:14 PM, Karsten Hilbert
karsten.hilb...@gmx.netwrote:
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
On Apr 22, 2013, at 10:05 AM, Moshe Jacobson wrote:
Not bad, but the transaction logs would fill up the file system.
I'm not sure I understand that comment. Why would the transaction logs be
particularly voluminous in this case?
Besides, it would not be worth it to set up a whole database
On 4/22/2013 10:05 AM, Moshe Jacobson wrote:
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?
if your file system supports it (ZFS, for
On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus x...@thebuild.com wrote:
Not bad, but the transaction logs would fill up the file system.
I'm not sure I understand that comment. Why would the transaction logs be
particularly voluminous in this case?
I assumed the logs would be shipping
On Mon, Apr 22, 2013 at 03:16:19PM -0400, Moshe Jacobson wrote:
Not bad, but the transaction logs would fill up the file system.
I'm not sure I understand that comment. Why would the transaction logs be
particularly voluminous in this case?
I assumed the logs would be shipping to
On 04/22/2013 12:16 PM, Moshe Jacobson wrote:
On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus x...@thebuild.com
mailto:x...@thebuild.com wrote:
Not bad, but the transaction logs would fill up the file system.
I'm not sure I understand that comment. Why would the transaction
On Monday, April 22, 2013, Moshe Jacobson 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.
The problem