Sunday, March 25, 2012

cant append multiple Diff backups to same file?...

I run two different types of backups on the same database.
A monthly full and nightly diffs appending to the same full file - file 'A'
A weekly full with 10 min trans log backups appending to same file - file
'B'- during working hours.
2 strategies, 2 backup files.
These are new strats that have gone live this week - tuesday in fact. The
monthly and weekly both ran fine on tuesday as did the nightly diff and all
the TS backups througout the day. last night - Weds - the nightly diff failed
with the following error:
"
Executed as user: <USERNAME>. Cannot perform a differential backup for
database "objectstore", because a current database backup does not exist.
Perform a full database backup by reissuing BACKUP DATABASE, omitting the
WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
"
Whilst the error is perfectly legible I dont understand what its implying -
cant I add multiple Diff backups to the same full backup OR is my weekly / 10
mins on the same database (but to a diff backup file) ballsing things up for
me somehow? If this is the case how come everything ran fine on tuesday night?
Any help gets beers.
THanks
Alastair Jones.I shoudl add that the chronology of the backups is as follows:
monthly init @. 7am first tues of month to file A
weekly init @. 7.30 Am tuesdays to file B
nightly diff to file A @. 2215 nightly
TL backups to file B every 10 mins
"Methodology" wrote:
> I run two different types of backups on the same database.
> A monthly full and nightly diffs appending to the same full file - file 'A'
> A weekly full with 10 min trans log backups appending to same file - file
> 'B'- during working hours.
> 2 strategies, 2 backup files.
> These are new strats that have gone live this week - tuesday in fact. The
> monthly and weekly both ran fine on tuesday as did the nightly diff and all
> the TS backups througout the day. last night - Weds - the nightly diff failed
> with the following error:
> "
> Executed as user: <USERNAME>. Cannot perform a differential backup for
> database "objectstore", because a current database backup does not exist.
> Perform a full database backup by reissuing BACKUP DATABASE, omitting the
> WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> "
>
> Whilst the error is perfectly legible I dont understand what its implying -
> cant I add multiple Diff backups to the same full backup OR is my weekly / 10
> mins on the same database (but to a diff backup file) ballsing things up for
> me somehow? If this is the case how come everything ran fine on tuesday night?
> Any help gets beers.
> THanks
> Alastair Jones.
>

No comments:

Post a Comment