sql server backups - what is physical_block_size?
0
votes
1
answer
111
views
we have recently changed the file server that is the repository (the place where the backups are stored) server .
I noticed the hardware specially IO is much better backup take shorter to finish, depending on many things, however, restores still take the same time as before.
this is not a complex question, I have only one question here:
what is
physical_block_size
?
when you run the following query on the msdb
database:
SELECT *
FROM msdb.dbo.backupmediafamily BMF WITH(NOLOCK)
order by 1 desc
this is the result of above query and please notice how the physical_block_size
changed from 4096 to 512 exactly when I decided to use our new server mentioned above for the destination of the backups:

Asked by Marcello Miorelli
(17274 rep)
Oct 18, 2024, 11:41 AM
Last activity: Nov 26, 2024, 04:27 PM
Last activity: Nov 26, 2024, 04:27 PM