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


Get-DbaDbExtentDiff

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

Screenshots

dbatools-Get-DbaDbExtentDiff

Examples

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

Author

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

Get-Help

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