It is important for us to have a systematic plan in order to protect the data as
ID: 3711324 • Letter: I
Question
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?
Explanation / Answer
Solution:
What is open database backup and close database backups?
An open database backup is used when we take the full backup of the system.
Close database backup is used when partial backup is needed to be done.
When do you use open database backup?
When there is a system or some instance failure has happened in the system then the open backup is required.
When do you choose close database backup?
When a partial backup needs to be taken then we choose close database backup, the difference is that it can be taken at any point in time, whether the server is working or in stealth mode.
What the server settings are required in order to implement open or close database backup?
This depends on the kind of server which we are using.
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.