Results 1 to 3 of 3

Thread: Database File and Disk Space

  1. #1
    Join Date
    Mar 2006
    Posts
    127

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Add another file to the db on other disk.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •