Script to Find Free Space in SQL Server Database
Stephen West ~
Modified: June 29th, 2016 ~ ~ 1 Minute Reading
- This topic has 2 replies, 3 voices, and was last updated 8 years, 9 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
you can use
sp_spaceusedto see how much free space there is in the database.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.
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.