Solved

SQL Differential Backup

Posted on 2009-07-16
12
290 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

732 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