Restore database, please complete and differences can be checked? Or want to complete a full backup of reduction before difference reduction?

CodePudding user response:

This is my understanding:
Complete, is to all entities (table structure, data, index, etc.) are rewritten again
Differences, is part of the definition structure and data differences, rewrite coverage,

You do two reduction, have what meaning

CodePudding user response:

reference 1st floor morliz son hin reply:

this is my understanding:
Complete, is to all entities (table structure, data, index, etc.) are rewritten again
Differences, is part of the definition structure and data differences, rewrite coverage,

You do two reduction, have what meaning?

I have a complete database, yesterday in the morning has been display is restored,
https://www.tqwba.com/x_d/jishu/227561.html
Have seen an article, and then just according to the different articles restore database, before long, I also don't know whether I behind the operation effect

CodePudding user response:

Reduction of the data, depending on the backup point source point,
1, a full backup, the reduction of time, no matter choose to complete, or difference, the result is the same,
2, differential backup, the reduction, choose different reduction, it is very fast,

The information you can reference:
A full backup and difference of Sql server backup