FULLY BACKUP DATABASE.
Update : I posted this post with only line. However I received many comments and questions asking different questions related to it. I have compiled all of them and modified this post.
Most asked Question : What is the best time when database should be backed up?
Answer : When everything is running perfect. This is the time when backup should be taken because in troubled time this is the backup required to be restored. The best backup is when system was running PERFECT.
Question : I am experienced DBA, what should be the frequency of backup when I am upgrading the system or modifying the database?
Answer : I am sure you already know answer as experienced DBA. Adding my 2 cents, just like any other DBA. Errors, mistakes and accidents do not discrimination based on experience of DBA.
Question : I am new to this area. Which is the best medium of the taking backup?
Answer : Every System Admin has their opinion based on company policy. We use SAN with RAID 10 configuration. In meeting with some senior architects of other prominent companies two weeks ago, they suggested we are overprotecting our database backup. Well, that is how I like my Database backup. Better safe than sorrow.
Question : Help! I did something wrong. I do not know what to do.
Answer : Take full backup of the database and pray.
Question : I want to learn more about database backup. Do you have any other suggestions?
Answer : Sure. Please visit Additional Articles to see more articles related to this articles. Additional Articles.
Reference : Pinal Dave (http://blog.SQLAuthority.com)