Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
DIfferential backup failure - invalid restore sequence. Options · View
armand
#1 Posted : Tuesday, May 15, 2012 1:35:16 AM Quote
Rank: Newbie

Groups: Registered

Joined: 5/15/2012
Posts: 1
Hello All
Here is config:
Soft: SqlBackupAndFtp 6.5.8.22232 Lite
Server: (Microsoft Windows NT 6.1.7600.0)
SQL: SQL 2005 Std
Config: Full backup at 4 AM + DIFF backup each 4 hours.

Problem: Differential backup eventually fail to perform.
15/05/12 08:00:30 ERROR: Backup of DBNAME failed: invalid restore sequence. 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 = 'DBNAME'. Original message: Cannot perform a differential backup for database "DBNAME", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
BACKUP DATABASE is terminating abnormally.

Checked: No additional backups run, no additional jobs run on same SQL, Full database Backup performed by same job via SqlBackupAndFtp, Zipped and in same place.


Any Ideas?
Thx in advance!
AlexP
#2 Posted : Tuesday, May 15, 2012 10:52:38 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 419
Hi,

Did you check result of SQL: SELECT * FROM msdb.dbo.backupset WHERE database_name = '<DBNAME>'?
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET MySql Backup MySql Backup to cloud Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups