SQL SERVER – One Thing All DBA Must Know


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)

14 thoughts on “SQL SERVER – One Thing All DBA Must Know

  1. 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.


  2. 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…


  3. 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.



  4. 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………



  5. 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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s