Shrink Database

• Steve Johnson

  Default port

  Points: 1404

  More actions

  September 24, 2001 at 10:33 am

  #104516

  How do I shrink the allocated space for a db. I have a database that has 26 gigs reserved but the physical space needed is 19 gigs. I want to bring that back down to 21 gigs.

  Steve Johnson

  
  Steve Johnson

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 24, 2001 at 10:54 am

  #418417

  If you're running SQL2000 just right click and select shrink database in EM.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Steve Johnson

  Default port

  Points: 1404

  More actions

  September 24, 2001 at 11:06 am

  #418418

  thanks, I have already done that but what I was missing was that we have 25 gigs of data in that database.... not sure how we got that much in this database it is a copy of another database which is only 19 gig

  Steve Johnson

  
  Steve Johnson

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737981

  More actions

  September 24, 2001 at 11:52 am

  #418422

  Was this a restores copy? Has any activity taken place?

  Steve Jones

  steve@dkranch.net

• Steve Johnson

  Default port

  Points: 1404

  More actions

  September 24, 2001 at 12:34 pm

  #418425

  I am moving a database from an old box to a new box, I used a "Copy SQL Server Task" to move the data only. We have done extensive work on the permissions and indexes on the new box and I don't want to loose those changes.

  Steve Johnson

  
  Steve Johnson