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 (https://blog.sqlauthority.com)

Database, SQL Backup and Restore, SQLAuthority Book Review
Previous Post
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
Next Post
SQL SERVER – Stop SQL Server Immediately Using T-SQL

Related Posts

14 Comments. Leave new

  • Praveen Barath
    August 6, 2007 12:30 am


    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…


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


  • 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………


  • Darshan shah
    June 9, 2008 7:04 pm

    Hi Anjan

    have u use this ?
    set deadlock_priority low

  • Darshan shah
    June 9, 2008 7:05 pm

    Hi vijay

    backup database dbname to disk =’path’

  • Darshan shah
    June 9, 2008 7:09 pm

    Hi pinal

    can u please review my answers ? so that i can know, i am going wrong or right?

  • Vijaya Kadiyala
    August 6, 2008 2:23 am

    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.


Leave a Reply