Solved

SQL Differential Backup

Posted on 2009-07-16
12
289 Views
Last Modified: 2012-05-07
I have a server with serveral SQL databases on it.  They are all in the default instance.  For one specific database I cannot run differential backups.  When I try it says that no full backup is available for the database even if I run a full backup directly prior to running the differential backup.  

Differential backups work with issue on all my other databases.  I am at a loss as to what could be going on.  The full backups appear to run correctly.  The full backups are good.  I can restore them without an issue and all of the data is there.  

It seems like for some reason something within SQL isn't recording that a full backup was done.

Any help is greatly appreciated.  
0
Comment
Question by:willettmeister
  • 7
  • 5
12 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24870196
>>  When I try it says that no full backup is available for the database even if I run a full backup directly prior to running the differential backup.

Kindly take Full backup once as mentioned
Differential backup needs a Full backup in place to work.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24870209
A differential Backup is nothing but the difference between the last Full backup and the current state.

If you haven't took any Full backup then you wont be able to take Differential backup right.
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24870390
Again this occurs even if I run a full backup directly before I run the differential backup.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24870479
Try the steps below once:

1. Take a Full backup and verify whether it was successfully done by restoring it back to another database.
2. Take a Differential backup and verify whether it was successfully done by restoring it back to the new database created.

Kindly run DBCC CHECKDB to check for any inconsistencies in your database.
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24870558
That is the process that I am following to test the backups.  

I cannot take a differential backup after I take a full backup.  
  The error I get is Connot perform a differential backup for database "db_name" becuase a current database backup does not exist.  

DBCC CHECKDB ran without issue.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'db_name'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24870573
BTW we use Networker to with the SQL module to perform the backups normally but this occurs if I do backups directly within the SQL management studio also.
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24870626
I have also seen the articles stating that NTbackup breaks the backup chain but that is not what is happening here.  I know for certain that ntbackup is not running in between my full and attempted diff backup.  I have also stopped the SQL VSS writer.
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24870651
i have also checked the msdb.backupset table and the FUll backup is recorded in there correctly.
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24871130
This should help you out:

http://support.microsoft.com/kb/921106
0
 
LVL 11

Author Comment

by:willettmeister
ID: 24871247
Thanks I have requested the hotfix and I will let you know if it fixes my problem.
0
 
LVL 11

Author Closing Comment

by:willettmeister
ID: 31604279
This hotfix did the trick thanks.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24877803
Welcome and glad to help you out.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question