Full Recovery Model

Question

Full Recovery Model

Viewing 14 posts - 16 through 29 (of 29 total)

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

Mike Palecek SSCommitted Points: 1560 More actions · Answer 1

Nice question,

I learned this a fun way when I created a new database and hadn't checked my email for a few hours. Came back to a full inbox saying my transaction log backups had failed...every 10 minutes, until I did a full backup of the new database.

Cliff Jones SSChampion Points: 10577 More actions · Answer 2

Interesting question that took some thought. Thanks for the explanation Hugo.

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

paul s-306273

SSChampion

Points: 10730

March 7, 2012 at 9:10 am

#1456075

Makes sense...

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 4

Great back-to-basics question!

I just wasn't too sure if SQL Server would allow the log backup to be made or not but Hugo's explanation was right to the point.

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 5

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA

Narud SSCrazy Points: 2837 More actions · Answer 6

tommyh (3/6/2012)
<cough>referense</cough>
/T

Here is:

- Working with Transaction Log Backups -

http://msdn.microsoft.com/en-us/library/ms190440.aspx

😉

Lon-860191 SSCrazy Points: 2449 More actions · Answer 7

Lon-860191

SSCrazy

Points: 2449

March 7, 2012 at 11:17 am

#1456149

Easy one, thanks!!

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 8

sjdnfkwejhniof (3/7/2012)
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====

Looks like there is a join predicate missing somewhere...

Best Regards,

Chris Büttner

TomThomson SSC Guru Points: 104767 More actions · Answer 9

Thanks for the nice straightforward question and answer.

The answer is of course wrong :-). You can take log backups after doing file backups, You never actually have to do a full backup. Of course any-one who doesn't start with a full backup is probably a nutcase (or worse :crazy:), but the system is actually designed to allow you to get away with file backups and log backups and no full backups :w00t:.

</pedantry>

Actually, I prefer the answer given to the pedantic one

Tom

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 10

I was looking for the trick question. I just wanted to go with my gut and click NO, but I thought MAYBE there was something that might make it possible. QOTD is making me paranoid 🙂

Easy one! (if you don't get paranoid!)

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 11

Good straightforward question. Thanks for submitting.

http://brittcluff.blogspot.com/

zymos SSCommitted Points: 1960 More actions · Answer 12

zymos

SSCommitted

Points: 1960

April 11, 2012 at 8:48 am

#1471910

Thanks for your response. 🙂

Dalton Moore SSC Eights! Points: 879 More actions · Answer 13

One of the first things I learned as an intern last year!

Hany Helmy SSChampion Points: 13926 More actions · Answer 14

too EZ 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
https://www.linkedin.com/in/hany-helmy-1845ab11b/