I'm running this code for backing up and to have backup log:
backup database adventureworks
to disk = 'g:radvent6.bak'
mirror to disk='g:radvent7.bak'
insert into HumanResources.department
backup log adventureworks
After the backup log command executes, it shows the error as:
The 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 1
BACKUP LOG is terminating abnormally.
What should I do? How could I correct it? Please suggest.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!