Hi All,
The recovery model for all of the db including system and users are set to simple. There is sql agent job which kicks off evey Sunday and perform database integrity check. It fails every time. Here is the sql agent error message:
Message
Executed as user: NT AUTHORITY\SYSTEM. ...e 50000) Server: xxxxxxx [SQLSTATE 01000] (Message 50000) Version: 11.0.7001.0 [SQLSTATE 01000] (Message 50000) Edition: Standard Edition (64-bit) [SQLSTATE 01000] (Message 50000) Platform: Windows [SQLSTATE 01000] (Message 50000) Procedure: [master].[dbo].[DatabaseIntegrityCheck] [SQLSTATE 01000] (Message 50000) Parameters: @Databases = 'USER_DATABASES', @CheckCommands = 'CHECKDB', @PhysicalOnly = 'N', @NoIndex = 'N', @ExtendedLogicalChecks = 'N', @TabLock = 'N', @FileGroups = NULL, @Objects = NULL, @MaxDOP = NULL, @AvailabilityGroups = NULL, @AvailabilityGroupReplicas = 'ALL', @Updateability = 'ALL', @TimeLimit = NULL, @LockTimeout = NULL, @LockMessageSeverity = 16, @DatabaseOrder = NULL, @DatabasesInParallel = 'N', @LogToTable = 'Y', @Execute = 'Y' [SQLSTATE 01000] (Message 50000) Version: 2019-02-10 10:40:47 [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:00 [SQLSTATE 01000] (Message 50000) Database: [BILicense] [SQLSTATE 01000] (Message 50000) Status: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Recovery model: SIMPLE [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:00 [SQLSTATE 01000] (Message 50000) Command: DBCC CHECKDB ([BILicense]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000) Outcome: Succeeded [SQLSTATE 01000] (Message 50000) Duration: 00:00:02 [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:02 [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:02 [SQLSTATE 01000] (Message 50000) Database: [Nectari] [SQLSTATE 01000] (Message 50000) Status: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Recovery model: SIMPLE [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:02 [SQLSTATE 01000] (Message 50000) Command: DBCC CHECKDB ([AliasXXX]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000) Outcome: Succeeded [SQLSTATE 01000] (Message 50000) Duration: 00:00:05 [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:07 [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:07 [SQLSTATE 01000] (Message 50000) Database: [NectariCubeXFTY] [SQLSTATE 01000] (Message 50000) Status: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Recovery model: SIMPLE [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:00:07 [SQLSTATE 01000] (Message 50000) Command: DBCC CHECKDB ([NectariCube]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000) Outcome: Succeeded [SQLSTATE 01000] (Message 50000) Duration: 00:31:33 [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:31:40 [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2020-12-20 04:31:40 [SQLSTATE 01000] (Message 50000) Database: [NectariV8] [SQLSTATE 01000] (Message 50000) Status: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Recovery model: SIMPLE [SQLSTATE 01000] ... The step failed.
Will setting the database recovery model to full solve this issue ?
Thanks
Mahmood