[Script Of Oct. 07] Get the information of used/free space of all SQL Server databases


Oct.
07
image

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/Get-the-information-of-9fcf67d7.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This T-SQL script will demo how to get the information of used/free space of all SQL Server databases in an instance.

As some people asked how to get the used or free space of all database in a SQL Server, this script will demo how to get the following information:

  • total size of data file(s)
  • total size of log file(s)
  • used space size of data file(s) +log file(s)
  • free space size of data file(s) + log file(s)
  • size of every data file and log file

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

Comments (1)

  1. aw says:

    You amazingly come with really good posts. Thanks a lot for sharing your blog Microsoft.

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Komunikasi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Listrik
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Management%20Trainee
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Manajemen
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Marketing
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Mekanik
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Mesin
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Metro%20TV
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Negeri
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Online
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Otomotif
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Pegawai%20Negeri
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Pendidikan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Penerbangan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Perawat
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Perikanan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Perkapalan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Perpustakaan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Persero
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Pertamina
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Pertanian
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Peternakan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Polisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Polwan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Pramugari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Programmer
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Psikologi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20PTN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20PTS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Reporter
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20S1
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20S2
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Sales
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Sastra
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Sekretaris
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Serpong
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20SMA
    http://www.lokerjobindo.com
    http://www.yacinta.com
    http://www.kerjabumn.com
    http://www.wisatasia.id/search/label/Wisata-Indonesia

    http://www.wisatasia.id

Skip to main content