downside to shrinking db

anushahanna
anushahanna used Ask the Experts™
on
When you have to do shrink on a db file, is there any 'critical' downside to it - like any loss of data etc.

the normal downside could be fragmentation, and could even be totally avoided if log backups are done etc.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
Hello anushahanna,
http://www.karaszi.com/SQLServer/info_dont_shrink.asp


Regards,

Aneesh
Awarded 2008
Awarded 2008
Commented:

Author

Commented:
Thanks for the links.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial