Wednesday, June 22, 2016

Estimate full backup size

BACKUP DATABASE <DatabaseName> to disk='NULL'

--Look closely to the output
--it will give an output like that:
--BACKUP DATABASE successfully processed 12345 pages in XXX seconds (YYY MB/sec).
--Backup size estimation = XXX * YYY

No comments:

Post a Comment