Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database size issues Expand / Collapse
Author
Message
Posted Thursday, August 20, 2009 8:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:22 AM
Points: 43, Visits: 105
I have as database that has a size of 65548.83 MB and the space available is 59386.77 MB. As you can tell there is a lot of free space. How do I reclaim this space and resize my database. I've tried a shrinkdatabase with truncateonly but that doesn't work.
Post #774264
Posted Thursday, August 20, 2009 8:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:22 AM
Points: 43, Visits: 105
SORRY for the 2nd posting - I hit the button by accident again I guess.
Post #774266
Posted Thursday, August 20, 2009 8:41 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 8:21 AM
Points: 92, Visits: 503
Do you know which files have grown? if its just the log files then you will need to take a transaction log backup and right after that finishes you should be able to shrink the files.
Post #774272
Posted Thursday, August 20, 2009 8:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 8:21 AM
Points: 92, Visits: 503
you might also want to check into the settings you have for automatic file growth, and look at what caused the database to grow to that size in the first place.
Post #774276
Posted Thursday, August 20, 2009 8:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:22 AM
Points: 43, Visits: 105
the mdf is the biggest file the log is only at 1 mb right now
Post #774282
Posted Thursday, August 20, 2009 9:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 8:21 AM
Points: 92, Visits: 503
If you go to enterprise manager and right click the database name and go all tasks, shrink database then click on the Files button. You can specify a size to Shrink the file to. Or if you would rather you could use DBCC SHRINKFILE.
Post #774300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse