[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL Differential Backup

Posted on 2009-07-16
12
Medium Priority
?
296 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 2000 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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

650 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