Show Available Disk Space in SQL Server
This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host.
This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host.
When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity.
Installing SQL is a straight-forward task… but it’s important that things are in-place from the get-go to prevent having to make changes on a live system.
If you’re backing up or restoring a large database in SQL Server, you can run the SQL script in this post to find out how long it has left to complete.