1.Find out the free space in the drives by
XP_FIXEDDRIVES
2.Check the free space in the mdf and ldf for all databases to shrink.
if free space available,shrink the mdf or ldf as like below image.
3.Check for any unarchived backup files available in the drive,if so,ask Archive team to fire a full backup.
4.Check which database has free space by
or
Thats'it
Hope you will clear the drive to get free space...
No comments:
Post a Comment