Physical and logical backup

difference between Physical and logical backup
rehman_jobAsked:
Who is Participating?
 
gnudiffCommented:
Not a very exact question, however, from what I believe you are asking about, the answer could be:

- physical backup:
* copy the server's db directories and files via operating system means
* usually does not guarantee you will be able to use the files with the db after copying them back
* can be faster than logical backup
* can take more place than logical backup, if you are copying also indexes.

- logical backup:
* extracts db structure and values via db backup utilities (frequently named 'dumps')
* usually guarantees you will be able to use them with db after using db restore facility (provided the backup process went OK)
* can be slower;
* with some DBs can lock the DB objects while backing them up;
* can take less or more place than physical backup, depending on their format (depends on DB)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.