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 prob
On 04/22/2013 12:16 PM, Moshe Jacobson wrote:
On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus 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
logs be particul
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 s
On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus 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 the slav
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 instance
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 Mon, Apr 22, 2013 at 12:14 PM, Karsten Hilbert
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
> > data
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
> databas
