Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do results of recovery contain less data than the original SQL Server database, backup and log?

April 26, 2017backup contain Data database log original recovery results SQL Server

0

Posted

Why do results of recovery contain less data than the original SQL Server database, backup and log?

1 Answer

0

Posted

This is normal. The damaged parts of your SQL Server database, backup and log will convert to zero size on output. The other common reason of file size decrease is when some of features of the original database, backup and log are not supported and therefore absent from the recovered database, backup and log. Demo-recovered database, backup and log is smaller because it mostly consists of demo placeholders than actual data.