dbatools is a free PowerShell module with over 300 SQL Server administration, best practice and migration commands included.

Please note that documentation and command names may be out of date while we work furiously towards 1.0


This is only an implementation of the script created by Paul S. Randal to find what percentage of a database has changed since the last full backup. SQL Skills




Get the changes for the DBA database.

Get-DbaDbExtentDiff -SqlInstance SQL2016 -Database DBA

Get the changes for the DB01 database on multiple servers.

Get-DbaDbExtentDiff -SqlInstance $SQL2017N1, $SQL2017N2, $SQL2016 -Database DB01 -SqlCredential $Cred


This command was created by Viorel Ciucu. You can find Viorel on Twitter and his blog.


From PowerShell, execute Get-Help Get-DbaDbExtentDiff -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaDbExtentDiff.ps1 on GitHub

Related commands