SQL Server 2008 database backup terminating abnormally

15 pts.
Tags:
Backup
Database Backup
SQL Server 2008
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'
with format,checksum,stop_on_error

use adventureworks
insert into HumanResources.department
(name,groupname)values('dreee','reserch')

backup log adventureworks
to disk='g:radvent6.trn'
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.

Software/Hardware used:
backup
ASKED: June 16, 2010  12:38 PM
UPDATED: April 3, 2014  5:19 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

u should have to change the recovery mode to full for the particular database.
then try on it it will work

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following