SQL Differential Backup

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.  
LVL 11
willettmeisterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>>  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
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
willettmeisterAuthor Commented:
Again this occurs even if I run a full backup directly before I run the differential backup.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
willettmeisterAuthor Commented:
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
willettmeisterAuthor Commented:
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
willettmeisterAuthor Commented:
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
willettmeisterAuthor Commented:
i have also checked the msdb.backupset table and the FUll backup is recorded in there correctly.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
This should help you out:

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
willettmeisterAuthor Commented:
Thanks I have requested the hotfix and I will let you know if it fixes my problem.
0
willettmeisterAuthor Commented:
This hotfix did the trick thanks.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Welcome and glad to help you out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.