InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:39:53 GMT20http://www.sqlservercentral.com/Forums/Topic938640-392-1.aspxAs the error clearly states, backup log is not allowed when the database is in simple recovery (which AdventureWorks is). If you want to plan with log backups, switch it to full recovery (alter database), take a full database backup and then you'll be able to make log backups.Wed, 16 Jun 2010 23:44:21 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic938640-392-1.aspxm running this code for backing up and to have backup logbackup database adventureworksto disk = 'g:radvent6.bak'mirror to disk='g:radvent7.bak'with format,checksum,stop_on_erroruse adventureworksinsert into HumanResources.department(name,groupname)values('dreee','reserch')backup log adventureworksto disk='g:radvent6.trn'after the backup log command executes shows the error asThe statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.Msg 3013, Level 16, State 1, Line 1BACKUP LOG is terminating abnormally.what should i do how could i correct it .pls suggest.Wed, 16 Jun 2010 22:01:29 GMTrino.raju