Full Recovery Model

Question

Post reply

Full Recovery Model

zymos

SSCommitted

Points: 1960
More actions
March 6, 2012 at 9:52 pm

#265550

Comments posted to this topic are about the item Full Recovery Model
March 7, 2012 at 1:24 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 29 total)

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

baabhu SSCertifiable Points: 6205 More actions · Answer 1

baabhu

SSCertifiable

Points: 6205

March 6, 2012 at 9:54 pm

#1455726

Thank you for the simple question. + 1 added.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

EZ PZ

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

M&M SSC-Insane Points: 21700 More actions · Answer 3

M&M

SSC-Insane

Points: 21700

March 6, 2012 at 10:48 pm

#1455737

Good one.

M&M

tommyh SSCertifiable Points: 6302 More actions · Answer 4

tommyh

SSCertifiable

Points: 6302

March 6, 2012 at 11:15 pm

#1455741

<cough>referense</cough>

/T

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Nice back to basics question. Very thorough reference though, took me hours to wield through 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

yannick.dinger SSC Veteran Points: 206 More actions · Answer 6

yannick.dinger

SSC Veteran

Points: 206

March 7, 2012 at 1:03 am

#1455777

easy and basic but i love it !!!!!!!!! :hehe:

paul.knibbs SSCoach Points: 15320 More actions · Answer 7

Wasn't the "explanation" more or less a repeat of the question? It really felt like "Is X true? Yes it is, because X is true!". Needed a reference at the very least.

Carlo Romagnano SSC-Insane Points: 22668 More actions · Answer 8

Carlo Romagnano

SSC-Insane

Points: 22668

March 7, 2012 at 1:48 am

#1455795

What do you mean for "created and loaded database"?

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 9

Stewart "Arturius" Campbell (3/7/2012)
Nice, simple back-to-basics question, thanks, Peter
For the explanation, refer to Working with Transaction Log Backups, specifically the third paragraph

+1

😎

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 10

Stewart "Arturius" Campbell (3/7/2012)
Nice, simple back-to-basics question, thanks, Peter
For the explanation, refer to Working with Transaction Log Backups, specifically the third paragraph

And to add to that reference, the reason for this is that a restore always has to start with the restore of a full backup. A full backup contains the information in the database at a given point; a log backup contains a list of changes. When you need to restore to a point in time, you HAVE to restore to the complete content of a previous point in time first, then reapply the changes by following the chain of log backups.

Without a starting point to base the changes on, a set of changes is useless. That's why SQL Server refuses to let you save such a set of changes. (In fact, when setting a database to FULL or BULK_LOGGED recovery, the actual running mode always remains SIMPLE until you take a full backup. And the same is true for newly created databases.)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

SqlMel SSCrazy Points: 2901 More actions · Answer 11

Good question. Got me thinking a little since I never tried this before.

@hugo: Thanks for the explanation. That rationalization of the restore process is what led me to the right answer.

---------------
Mel. 😎

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 12

Hugo Kornelis (3/7/2012)
(In fact, when setting a database to FULL or BULK_LOGGED recovery, the actual running mode always remains SIMPLE until you take a full backup. And the same is true for newly created databases.)

Ooohh... did not know that, never thought about it since I start backups immediately, but that is good to know. This implies that therefore should a backup be forgotten, the changes are immediately lost even to a log reader should a transaction log backup be taken later on after the full backup. Good to know indeed.

EL Jerry SSCertifiable Points: 7063 More actions · Answer 13

Nice and easy, but still got me thinking a little bit 🙂

@hugo, thank you for the explanation, clear and concise.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]