DIFFERENTIAL BACKUP ERROR

Hi ,
I am running a job for taking a differential back up of a Merge replicated
database.
in week days the differential backup will run and on sunday the normal
backup will overwrite the differential back up.again from monday differentia
l
back up will start.
the backup job is running correctly.when i try to restore the differential
back up it's working upto 4th day.for 5th and 6 th its not working and givin
g
an error.
here i am listing my backup job code
declare @.Weekday INT
SET @.Weekday=0
SET @.Weekday=datepart(weekday,getdate())
IF @.Weekday<>1
BEGIN
BACKUP DATABASE DIFFBACKUP
TO DISK ='F:\BackUp\DIFFBACKUPBACKUP.DAT' WITH DIFFERENTIAL ,
NOUNLOAD , NAME = N'DIFFBACKUPBACKUP', NOSKIP ,
STATS = 10, NOFORMAT
END
IF @.Weekday=1
BEGIN
BACKUP DATABASE DIFFBACKUP
TO DISK ='F:\BackUp\DIFFBACKUPBACKUP.DAT' WITH INIT ,
NOUNLOAD , NAME = N'DIFFBACKUPBACKUP', NOSKIP ,
STATS = 10, NOFORMAT
END
Please help.i am unable to identify the problem.
thanks,
reddy.reddy
What is an error that you've got?
"reddy" <reddy@.discussions.microsoft.com> wrote in message
news:057BCACB-136F-42A4-82C4-3613A94B222B@.microsoft.com...
> Hi ,
> I am running a job for taking a differential back up of a Merge replicated
> database.
> in week days the differential backup will run and on sunday the normal
> backup will overwrite the differential back up.again from monday
differential
> back up will start.
> the backup job is running correctly.when i try to restore the differential
> back up it's working upto 4th day.for 5th and 6 th its not working and
giving
> an error.
> here i am listing my backup job code
> declare @.Weekday INT
> SET @.Weekday=0
> SET @.Weekday=datepart(weekday,getdate())
> IF @.Weekday<>1
> BEGIN
> BACKUP DATABASE DIFFBACKUP
> TO DISK ='F:\BackUp\DIFFBACKUPBACKUP.DAT' WITH DIFFERENTIAL ,
> NOUNLOAD , NAME = N'DIFFBACKUPBACKUP', NOSKIP ,
> STATS = 10, NOFORMAT
> END
> IF @.Weekday=1
> BEGIN
> BACKUP DATABASE DIFFBACKUP
> TO DISK ='F:\BackUp\DIFFBACKUPBACKUP.DAT' WITH INIT ,
> NOUNLOAD , NAME = N'DIFFBACKUPBACKUP', NOSKIP ,
> STATS = 10, NOFORMAT
> END
> Please help.i am unable to identify the problem.
> thanks,
> reddy.
>
>
>|||The error is
can not apply the backup on device 'c:\mssql\test.dat' to database test
restore database is terminating abnormally.
the backup job aim is from monday to saturday differential backup, on sunday
normal backup will overwrite all the differential backups.i am able to
restore differential backups till thursday.after that any backup i am unable
to restore.i am getting the above error.
your help is appreciated.
thanks
reddy.
"Uri Dimant" wrote:

> reddy
> What is an error that you've got?
> "reddy" <reddy@.discussions.microsoft.com> wrote in message
> news:057BCACB-136F-42A4-82C4-3613A94B222B@.microsoft.com...
> differential
> giving
>
>