When you get this alert in the MS SQL 2012 server, then you probably haven’t managed to perform a full backup and transaction log backup of the database after creating the database the first time. This is when you have “Recovery model” set to full. Run this command in the editor for that database:
BACKUP DATABASE [DATABASENN] TO DISK = N’e:\mssql\backup\DATABASENN_1.bak’
GO
BACKUP LOG [DATABASENN] TO DISK = N’e:\mssql\backup\DATABASENN_1log.bak’
GO
Read more:
http://support2.microsoft.com/kb/2646329
http://stackoverflow.com/questions/3131258/backup-failed-to-complete-the-command-backup-database
Obtained's Blog 