It is important for us to have a systematic plan in order to protect the data asset of any organization. Thus, it is critical for us to understand our options for backing up and recover a database. The discussion of this week focus on possible ways to backup a database.

Questions:

What is open database backup and close database backups?

When do you use open database backup?

When do you choose close database backup?

What the server settings are required in order to implement open or close database backup?