SQL Backup size

Siva 646

Hi,

Do we have any powershell script to identify the sql db size from the SQL backup history? using the SQL in Azure VM Backup.

Alberto Morillo 32,891 Reputation points MVP

2021-11-25T10:36:09.87+00:00

Are you talking about native backups created on a SQL Server VM or you are talking about backups created using an Azure Backup server?
Siva 646 Reputation points

2021-11-25T12:28:57.2+00:00

It is about the Azure SQL Backup
Siva 646 Reputation points

2021-12-02T03:37:35.19+00:00

Hi Team,

Can anyone assist on this? If possible.
SadiqhAhmed-MSFT 37,921 Reputation points Microsoft Employee

2021-12-03T13:45:37.09+00:00

@Siva There is SQL query which can fetch you backup size.

SELECT
database_name,backup_size,user_name,first_lsn,last_lsn,checkpoint_lsn,database_backup_lsn,database_creation_date,backup_start_date,backup_finish_date,is_copy_only
FROM msdb.dbo.backupset
Oury Ba-MSFT 16,241 Reputation points Microsoft Employee

2021-12-06T17:33:42.047+00:00

@Siva Did the answer provided by @SadiqhAhmed-MSFT helpful.? If yes, please mark as accepted answer.

Regards,
Oury
Siva 646 Reputation points

2021-12-08T00:12:49.627+00:00

Hi OuryBa,

I dont have access to sql, so i cant check on this and update.