cancel
Showing results for 
Search instead for 
Did you mean: 

Differential backup fails SQL 2008

jtorrescobar
Level 3
Partner

Hi,

 

change server hardware SQL server BD 2008 placing the same name are now only doing the full backup but not the differential backup. The error message indicates that you need a full backup to perform differential. Was performed following the agent was reinstalled

 

 

thanks & regards,

 

José Torres

 

 

 

 

 

 

3 REPLIES 3

Donald_Eady
Level 6
Employee Accredited

Jose, 

    Take a look at the following document... 

http://www.symantec.com/docs/TECH58674

Make sure that you have no other software backup up your SQL server... are you doing SQL log backup to truncate the transaction logs... if so are they falling between the full and differential backups? 
 

pkh
Moderator
Moderator
   VIP    Certified

If the SQL machine is a VM, then you cannot do a VM backup between your full and incremental backups.

Anuj_Kr
Level 4
Partner Accredited

Please check if you are also doing your SQL database backup using SQL Management Studio. If so stop it for something & try a Full & then an incremental after sometime.