Shrunk data file in sqlserver2008

• RK2012

  SSC Eights!

  Points: 960

  More actions

  November 23, 2012 at 4:24 am

  #393656

  we have shrunk a datafile in production is there any impact

  Please suggest.

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  November 23, 2012 at 4:37 am

  #1561824

  RK2012 (11/23/2012)

  ---

  we have shrunk a datafile in production is there any impact

  Please suggest.

  .

  Shrinking a datafile is not a good idea, as many of the other folks here will tell you

  One of the reasons is that you will probably end up with huge fragmentation

  See these:

  http://www.sqlservercentral.com/articles/SHRINKFILE/71414/

  http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(930)-data-file-shrink-does-not-affect-performance.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 23, 2012 at 5:05 am

  #1561832

  Go rebuild all your indexes.

  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

• RK2012

  SSC Eights!

  Points: 960

  More actions

  November 23, 2012 at 5:28 am

  #1561841

  Thanks