.mdf 56GB TOO BIG HELP
-
I have database mdf file that is 56GB but my server only has 68.7 hard drive space. That means I have about 7mb left of space. How can fix this problem?
Chad
-
Get a bigger hard drive?
Seriously, if the database has 50 odd GB of data in it, you can either delete unnecessary data or get more storage space.
How much of that 56 GB is used and how much is free space?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
adding to what Gail said, here's screenshots of where in SSMS to see how much you could release by shrinking the database.
you might want to move any existing backups off to another drive as well to free up space.
if this machine is used for anything else, you might need to release space by clearing temp files, recycle bin, etc.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
What is using up the other 12 gig ? Maybe something else can be moved off the drive ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply