x

Is the recovery mode of a database saved in a backup

Hi,

If I have a database in Full Recovery and create a backup and then change it to Bulk Logged or Simple and then Restore the backup will the recovery mode change back to Full?

[Note: this is a seeder question. If you have over 2k reputation then please hold off adding an answer for 7 days (20/Mar/2010)]

more ▼

asked Mar 13, 2010 at 02:37 PM in Default

avatar image

Fatherjack ♦♦
43.8k 79 99 118

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Without testing this specific scenario - YES. I am assuming the overwrite is selected, you are restoring back to the same server, etc.

My scenario is that we backup a database that is in full mode, restore it on another server. What I have done in the past is change the recovery model on the target server and then let the restore overwrite it. The recovery model on the target server will change back to that of the source server upon restore.

more ▼

answered Mar 13, 2010 at 02:47 PM

avatar image

CirqueDeSQLeil
5.5k 11 13 20

(comments are locked)
10|1200 characters needed characters left

The answer is Yes

more ▼

answered Mar 14, 2010 at 04:14 AM

avatar image

Steinar
1.7k 4 6 10

(comments are locked)
10|1200 characters needed characters left

I'll answer your question with a question. If you backup the database while it is using the Full Recovery Model, and subsequently change the recovery model of the database to Simple of Bulk_Logged, how would the backup know it was changed when you restore it?

Yes, if after you subsequently change the recovery model, you then restore to that particular backup file the recovery model will change back to Full.

more ▼

answered Mar 15, 2010 at 09:51 AM

avatar image

Lynn Pettis
275 2 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x247
x129
x26
x8

asked: Mar 13, 2010 at 02:37 PM

Seen: 1723 times

Last Updated: Mar 13, 2010 at 03:22 PM

Copyright 2017 Redgate Software. Privacy Policy