gvel19
New User
Joined: 20 Jul 2008 Posts: 19 Location: Schenactady, US
|
|
|
|
1)Why do we take the back up of a table (Image copy) when we are going to update/Insert a record into a table.What will happen if we are not taking the backup of a table.
2)Whether we need to take backup while Insertion,Deletion and updation of a table.
Need a detailed explanation.Please..
Thanks,
velmurugan G |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Why do we take the back up of a table (Image copy) when we are going to update/Insert a record into a table.What will happen if we are not taking the backup of a table. |
If you do not take appropriate backups, you will most likely lose some part or all of your data one day. This could be due to disk problems, human error, or natural disaster (flood, etc).
Quote: |
Whether we need to take backup while Insertion,Deletion and updation of a table. |
The backup strategy is typically for a wider range than just one table. Databases or systems are usually backed up so they may be recovered. Additionally, there are cases when a backup is made of only 1 or a few tables. This will depend on your requirements (your organization must define them). Backups are not taken while the updates are taking place - backupa are done before or after. |
|