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 (https://blog.sqlauthority.com)
14 Comments. Leave new
THE BEST TIME TO TAKE BACKUPS:
The best time to backup is at OFF-PEAK-HOUR ….
Its fun learning from u.I have discovered a right person for all my queries…
Cheers….
I appreciate you for such a informatic site. Thanks….Would you be please guide me in preparing for the interview. I am from a different background where i have 8 years of experience. I want to move to IT and i choose DBA. That is I am fresher. Can you please guide me and give me the questions.
How can i export data in execel file in predefined excel format…
Example suppose one excel file like..
Report of newmwmber os year 2000 are following — this is fix as header (for every ouput)
field name —-these are fields name
data — -these are data
.
.
.
.
.
so, hearder is not in sql data…
i want this solution…
Hi pinal,
How to fix this issue in sql sever
“Transaction (Process ID 81) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Item cannot be found in the collection corresponding to the requested name”
How to resolve this issue as i am facing lot of problem because to this deadlock.Please help me to fix this issue.
Thanks,
AnjanA
how to take the back up in SQL SERVER 2005 in Script SQL format
pls help me.
i want make databasemaintainance plane through enterprise manager accept ‘sa’ Logins. what i will do.
Hi,
Am very much impressed by ur articles,they are simply superb……..
Am new to sql and wanted to learn,am not getting from where to start.so can you please give me some idea such that it will be useful for me to start in a right way.
any how thanks once again for amazing wonderful articles.
please continue………
Thanx
Bhavani
Hi Anjan
have u use this ?
set deadlock_priority low
Hi vijay
backup database dbname to disk =’path’
Hi pinal
can u please review my answers ? so that i can know, i am going wrong or right?
very good piece of information
hi pinal
how to export log files and .dmp files from a server
Pleas enote your grammar and spellling leaves much to be desired.
Also the statement ..
“Question : Help! I did something wrong. I do not know what to do.
Answer : Take full backup of the database and pray”
.. is not helpful and wrong since making backups of mistakes solves nothing.