Change from Full to Simple Recovery, what to do with the Log file?

Question

Change from Full to Simple Recovery, what to do with the Log file?

Viewing 4 posts - 16 through 20 (of 20 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

Well Kit, Gus just said everything I was going to... and since we both know he's always right... :w00t:;-)

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Kit G SSCrazy Points: 2888 More actions · Answer 2

WayneS (11/3/2010)
Well Kit, Gus just said everything I was going to... and since we both know he's always right... :w00t:;-)

heh. Probably best if I just nod wisely at this point. :hehe:

-- Kit

GSquared SSC Guru Points: 260824 More actions · Answer 3

WayneS (11/3/2010)
Well Kit, Gus just said everything I was going to... and since we both know he's always right... :w00t:;-)

You're the third person to accuse me of that.

The first was me.

The second was Phil Factor (from Simple-Talk).

So it must be true! :w00t:

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

WayneS SSC Guru Points: 95461 More actions · Answer 4

Kit G (11/3/2010)
WayneS (11/3/2010)
Well Kit, Gus just said everything I was going to... and since we both know he's always right... :w00t:;-)
heh. Probably best if I just nod wisely at this point. :hehe:

or sarcastically... 😀

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2