Link to home
Create AccountLog in
Avatar of yrcdba7
yrcdba7Flag for United States of America

asked on

disk space low for sql server data file only

Expert,

I have one disk hold one data file which is .mdf.  The disk space is low, I shrinked the data file, but it s size didn't shrink to smaller, can you advise what can I do to get more space without add more drive.

Thanks,

Lynn
ASKER CERTIFIED SOLUTION
Avatar of knightEknight
knightEknight
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account

Just get a bigger capacity disk

Continually shrinking the database does not help

In the meantime you can try and delete temporary files from the disk or uninstall unneccessary applications
Avatar of yrcdba7

ASKER

there is no temporary files on disk, only one file .mdl file.
Avatar of yrcdba7

ASKER

Thank you so much, it was big help in that moment.  You are great!

Thanks,

Lynn