Sunday, February 20, 2022

Backup of logs failed in SQL Server

 Can’t backup in RECOVERY SIMPLE mode. Insure RECOVERY FULL Mode is set:

-- to check recovery ode
SELECT name, recovery_model_desc  
   FROM sys.databases  
      WHERE name = 'Forecast' ;  
GO 

use Forecast;
ALTER DATABASE forecast SET RECOVERY FULL ; 

USE Operations
GO

ALTER DATABASE Operations SET RECOVERY FULL;


USE CreditRequest
GO

ALTER DATABASE CreditRequest SET RECOVERY FULL;



USE FortKnox
GO

ALTER DATABASE FortKnox SET RECOVERY FULL;


Use Model
GO

ALTER DATABASE FortKnox SET RECOVERY FULL;

Also need to do a full backup so that you could do incremental backup of log again:

Solution: BACKUP LOG cannot be performed because there is no current database backup. So run the FULL backup jobs again and should be good.

No comments: