|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
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
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 180
|
This may happen if you use other software to backup the database to other media. To track the backup history you may use the following statement: SELECT * FROM msdb.dbo.backupset WHERE database_name = 'Contacts'
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
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?
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 180
|
Please double check if there isn't any record with snapshot backup or any defferent catalog_family_number, catalog_media_number values.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/22/2012
Posts: 2
Location: NC, USA
|
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?
|
|
|
|
|
