June 26, 2013 at 6:00 am
Hi Team,
Today's Physical backup size in D: Drive is showing 21GB.
but when i run the below query, it is showing 43260149.000000 KB means 41GB.
Query....
SELECT physical_device_name,
backup_start_date,
backup_finish_date,
backup_size/1024.0 AS [Backup Size (KB)]
FROM msdb.dbo.backupset b
JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
WHERE database_name = 'TRACK'
ORDER BY backup_finish_date DESC
Please suggest
June 26, 2013 at 6:08 am
are you using compression while backing up the database?
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
June 26, 2013 at 6:09 am
No Sir,
June 26, 2013 at 6:12 am
Are you using a third party tool to perform the backup?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
June 26, 2013 at 6:13 am
No, simple t-sql backup commmand only.
June 26, 2013 at 6:20 am
The calculation is wrong, it should be
(backup_size/1024)/1024
I think
I did it with a quick test of a non compressed, T-SQL only backup here and the value tallied with the physical file.
June 26, 2013 at 6:21 am
SELECT sum(backup_size/1024.0) AS [Backup Size (KB)]
FROM msdb.dbo.backupset b
JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
WHERE database_name = 'Track'
group by b.backup_set_id
--ORDER BY backup_finish_date DESC
Post the result of this query....
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
June 26, 2013 at 6:30 am
Thank u,
It's working.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply