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:
Post a Comment