5
votes
1answer
2k views

How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. The problem is, the differential backups don't always seem to ...
4
votes
2answers
365 views

Can I manually reset the “internal status flag for a full database backup”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. This worked last weekend, however this weekend the differential ...
3
votes
2answers
1k views

Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?

I'm still struggling to understand SQL's backup jobs. We currently have a SQL Server 2005 instance using the FULL recovery model. We do a full database backup every week. BACKUP DATABASE ...