Hi
I could simply create backups with incrementing levels, move the
backup to the other server(s) and apply them there (that database is
offline).
However, I suspect there is a limit for the number of backup levels a
database can have.
You don't need a lot of backup levels to do what
Hi
There is no formal limit, ...
Is there a negative effect on too many levels?
(Slowdown or database storage overhead?)
Regards,
Steffen
Steffen Heil (Mailinglisten) skriver:
Hi
I could simply create backups with incrementing levels, move the
backup to the other server(s) and apply them there (that database is
offline).
However, I suspect there is a limit for the number of backup levels a
database can have.
You
I understand your problem. Would it be possible to measure the size of each
level 5 backup, and if it's over a certain threshold use a higher
level for the rest of that day to keep from copying the same large set of data
over and over?
In essence, you would create a script that backs up every
Hi,
I back with this question. Is this really correct because after discussion with
team i have now doubt.
We have here parenthesis. Any expression in parenthesis should be first
calculated
Then this is not test
NOT NULL - NULL only
Not ( NULL - NULL)
Regards,
Karol Bieniaszewski
-
liviusliv...@poczta.onet.pl skriver:
Hi,
I back with this question. Is this really correct because after
discussion with team i have now doubt.
We have here parenthesis. Any expression in parenthesis should be
first calculated
Then this is not test
NOT NULL - NULL only
Not ( NULL -
There is no formal limit, ...
Is there a negative effect on too many levels?
(Slowdown or database storage overhead?)
No negative effect.
The database does track the ID of the last backup at each level, so you would
have 2 or 3 more entries that the typical usage, but the details are
Every operating system has some limit on environment strings like command
line, that can be a problem on restore where the every level's filename
should be supplied.
Not sure if it's a theoretical or practical problem in Your case.
I use 3 levels (0 - friday night, 1 - every other weekday night,