Simple recovery mode to Full question

Question

Simple recovery mode to Full question

fizzleme

SSCertifiable

Points: 6906
More actions
April 28, 2016 at 3:39 pm

#313546

When I convert the recovery mode to Full from Simple and try to back up the log, the system says that is not possible because recovery mode is Simple. I must be forgetting a step. Help please.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 29, 2016 at 12:12 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Take a full or differential backup.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

fizzleme SSCertifiable Points: 6906 More actions · Answer 2

can I say well duh!

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

fizzleme (4/28/2016)
can I say well duh!

I can't tell if this is sarcasm or not, but Gail is (obviously) correct. Before you can take a transaction log backup you need to take a full (or diff) backup first, because until you do the database is operating in "pseudo-simple" mode.

fizzleme SSCertifiable Points: 6906 More actions · Answer 4

Thanks Team.

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.