Index !!!!

Question

Index !!!!

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

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

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

Backup log, yes.

Explicit truncation of log, no.

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

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 2

GilaMonster (9/26/2012)
Backup log, yes.
Explicit truncation of log, no.

But then if truncation of log is not to be done then what should i answer this???

Like i will be asked that why am i not truncating logs then??? 🙁

************************************
Every Dog has a Tail !!!!! :-D

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

runal_jagtap (9/26/2012)
GilaMonster (9/26/2012)
Backup log, yes.
Explicit truncation of log, no.
But then if truncation of log is not to be done then what should i answer this???
Like i will be asked that why am i not truncating logs then??? 🙁

Please go and read the article I referenced in my first reply in this thread.

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

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 4

Sure Gila, Thanks 🙂

************************************
Every Dog has a Tail !!!!! :-D