how n where to find disk space?

  • hello,

    I loged in sql server instance, I need to know how much disk space is there so where to check it?

  • Disk space is an OS function. you check the server itself to find this out. SQL Server has space reserved in its files, and sp_spaceused (and numerous other scripts) can help here. If SQL needs more space, and the databases are configured to grow, it asks the OS for space. It doesn't manage it.

    xp_fixeddrives can be used inside SQL Server for gross numbers.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply