Sql Backup And FTP

Hi, I'm having difficulty in SQLBackupAndFTP differrencial schedule backup, full backup always does normally, but when trying to backup Differential returns the following error.

BACKUP DATABASE is terminating abnormally.



12/29/2011 11:00:37 AM Contacts to Creating backup of C: \ Windows \ TEMP (differential)

12/29/2011 11:00:37 AM ERROR: Backup of Contacts failed: Can not perform a differential backup for database "Contacts", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.


This is an example and it happens to all databases that are on the server.

How to solve this problem? I've tried to do the full backup and Differential run, but always gives error.


My routine is as follows:

A full backup every day always 22hs
Differrencial a backup every 1 h


Thanks

hi,

I checked all the bases with the command:

SELECT * FROM msdb.dbo.backupset

It returned 25,464 rows

checked and no other program that backs up the sql with the sqlbackupandftp.

I noticed that when I reconfigure it sometimes backs up diff, but after a while to do and shows that the error reported earlier.

Any tips?

I have this same error. After reading this post I know I caused it because I used SQL Server Studio to do a snapshot to create a test database. How do I repair this so that SQLBackupAndFTP will resume doing full backups? Also when I need to refresh my test system copy from production can I restore the SQLBackupAndFTP full backup of my production database to the test database?