Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

good to shrink SQL DB

Hi Experts,

I am using the SQL server 2005 and 2008.
I have read some news about shrinking a file. its not good to do this.
What is your opinion ?
When I shrink my logfile do I have to do some post steps ? maybe with the index ?
0
Eprs_Admin
Asked:
Eprs_Admin
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
It is generally accepted practice that shrinking a data file is a bad idea - can cause internal fragmentation of your data file.  Google "Is shrinking a SQL server datafile bad" and you'll see lots and lots of forum posts and blog entries on it.

As for shrinking a log file, have a read of this article: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_11077-How-to-shrink-a-bloated-log-file.html

Feel free to come back with any questions on that.
0
 
Eprs_AdminSystem ArchitectAuthor Commented:
Thanks a lot.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now