Home » Blog » Topic » Script to Find Free Space in SQL Server Database

Script to Find Free Space in SQL Server Database

Stephen West ~ Modified: June 29th, 2016 ~ ~ 1 Minute Reading

Home › Forums › Script to Find Free Space in SQL Server Database

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • June 29, 2016 at 6:51 am #2338 Score: 0
    Stephen West
    Moderator
    4 pts

    Is there any way to find the free space of my database files? I have found some DBCC commands for it but don’t know how to use them.

    July 2, 2016 at 12:27 pm #2360 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    you can use sp_spaceusedto see how much free space there is in the database.

    July 4, 2016 at 1:03 pm #2382 Score: 0
    Dexter Morgan
    Moderator
    38 pts

    You can also take the help of DBCC SQLPERF (logspace) command to check free space for a SQL Server. It helps to give the information of size of transaction log files for each database.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.