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
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
