Solved

SQL Differential Backup

Posted on 2009-07-16
12
291 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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 Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

688 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