Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

Recently a friend contacted me about the error he is getting while setting up SQL Server Always On Availability Group for Always On.

Error:

Solution:

Once we create a new SQL Database in full recovery mode and have not taken a full backup, the database acts as in Pseudo simple recovery mode. Therefore, you require the first full backup to start the LSN chain for backup.

The fix of this error is simple as below.

• Take a full backup of the database – DBBlogger.

• Add the database in the SQL Server Always On Availability Group for Always On

Note: Do not take a full backup with COPY_ONLY mode as it does not create the LSN chain.