Tuesday, September 14, 2010

SHRINKFILE

Finnaly i understand how it work.
When to shrinkfile.
1) when ldf is too huge.

can i shrink the file? CAN
most site not encourage. but here i can understand some of the info i get.
1) shrinkfile probably not influnce data in DB. i means the consistency and accurancy is remain same.
2) what will lost when we shrinkfile. the info for trace back.
3) same to other site. the shrinkfile will not remove the active process in log file.
when truncate.