Can we estimated / predict the full backup size of the database
When ever i had the discussion with my mates, most of the common answer is
we can find the estimated backup size by checking the old full backups and estimated it roughly
or
DB backup size is equal to the database size.
These are the common answer i have received.
Question is still on ??? Can we estimated the backup size..
YES, WE CAN ESTIMATE THE EXACT SIZE OF THE DATABASE BACKUP BEFORE TAKING THE BACKUP.
Now how is that possible. Very simple.
Log into that database and
execute the below command
sp_spaceused
Highlighted below is the clear description:
Above Master database size is 5.25 MB but the reserved size "2488" KB.
When ever i had the discussion with my mates, most of the common answer is
we can find the estimated backup size by checking the old full backups and estimated it roughly
or
DB backup size is equal to the database size.
These are the common answer i have received.
Question is still on ??? Can we estimated the backup size..
YES, WE CAN ESTIMATE THE EXACT SIZE OF THE DATABASE BACKUP BEFORE TAKING THE BACKUP.
Now how is that possible. Very simple.
Log into that database and
execute the below command
sp_spaceused
Highlighted below is the clear description:
Above Master database size is 5.25 MB but the reserved size "2488" KB.
Reserved size is the exact size of the database backup.
how simple is it.
Hope the above post helps.
Thanks
Thanks
