April 8, 2007 at 12:43 pm
Hi,
I would like to know the size of the backup.
This will be helpful for me to allocate the reqd space when resotring the backup for recovery.
This is the ultimate requirement for both full,transaction log backups .
Can anyone give me some information on this.
Any help will be of great useful.
Dhathri
April 8, 2007 at 3:44 pm
Check msdb..backupset system table which contains backupsize column...
MohammedU
Microsoft SQL Server MVP
April 11, 2007 at 4:20 am
You can use something like this:
USE msdb
go
DECLARE @date datetime
SET @date = floor(convert(float,getdate()))
SELECT backup_start_date,database_name, type, CONVERT(decimal(20,2),
backup_size * 1.0/1024/1024) as MB,
CONVERT(varchar(12), backup_finish_date - backup_start_date,108) as BackupTime
FROM backupset
WHERE backup_start_date BETWEEN @date AND DATEADD(day,1,@date)
ORDER BY database_name,backup_start_date
But for the Log backups keep in mind thast the size of these can vary a lot, depending on the the number of transactions.
Markus
[font="Verdana"]Markus Bohse[/font]
April 11, 2007 at 5:56 pm
Hi,
Thank you all, for helping me to get the required backup size from the msdb database.
It really saved a lot of time for me.
Dram.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply