Blog Post

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:

Database might contain bulk-logged changes that have not been backed up

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.

Original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating