Re: Full Backup Not Found
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Wed, 16 Jul 2008 20:15:08 +0300
Hello Dan,
Take a look at the following KB:
http://support.microsoft.com/kb/921106
And you can query msdb.backupfile to track your file backups.
--
Ekrem Önsoy
"Dan" <dantheriver@xxxxxxxxxxx> wrote in message news:%23JAhwC25IHA.192@xxxxxxxxxxxxxxxxxxxxxxx
I have set up an agent job to do a full backup in the morning and a diff later in the day. If I run the full backup and the diff immediately afterwards it works fine. When I run the full backup and then wait several hours to run the diff, then I get this error:
=========================
Msg 3035, Level 16, State 1, Line 1
Cannot perform a differential backup for database "DW", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
=========================
The full database backup file is still in the original location, and is showing up in the SSMS when I open the restore db dialog for the database.
What would cause the diff backup to not be able to see the full backup?
Is there a TSQL command to list all the backups that have been taken for a given database?
.
- References:
- Full Backup Not Found
- From: Dan
- Full Backup Not Found
- Prev by Date: Re: Install SQL Expr after DEV Edition
- Next by Date: Re: Error re-installing SQL Server 2005
- Previous by thread: Full Backup Not Found
- Index(es):
Relevant Pages
|
