Database File and Disk Space

Hi All,

One of the drives that stores the database file is close to running out of space. The chance of me getting more space added to this drive any time soon are really low. What are other options I have?

Thanks.

Add another file to the db on other disk.

See how much of allocated space is actually used. You can use

sp_spaceused

to get that information or you may use EM. You can shrink log and data files if they have room.