SQL SERVER – First Month as DBA Trainee – Disasters and Recovery

SQL SERVER - First Month as DBA Trainee - Disasters and Recovery TSQL2sDay This blog post is written in response to the T-SQL Tuesday hosted by Allen Kinsel. He has selected very interesting subject for T-SQL Tuesday – Disaster and Recovery. This subject took me in past – my past. There were various things, I had done or proposed when I started very first month as a DBA trainee. I was tagged along with very senior DBA in my organization who always protected me or correct my mistake. He was great guy and totally understand the young mind of over-enthusiastic Trainee DBA. I respect him very much.

Here are few things which I had learned in my very first month (not necessarily I have practices them on production).

  • Never compress (zip) native backup using any tools, when disaster happen sometime the extra time to un-compress the database can be too long and not acceptable for business SLA
  • Do not truncate logs
  • After restoring full database backup – only restore latest differential back, no need to restore all the backup
  • Always write WHERE condition when deleting and updating

Sr. DBA always advised me – always keep your résumé ready and car ready – you never know when you can not recover disaster! Well for sure it was a joke. Today’s T-SQL Tuesday remind me of my very first month as DBA trainee.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Extending SQL Azure with Azure worker role – Guest Post by Paras Doshi
Next Post
SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Related Posts

6 Comments. Leave new

  • Hi ,
    i am completely agree and always follow these points. Last one is most important.
    Thx for sharing this.

    Reply
  • I thought i was suppose to truncate the log when ever i took a log backup. Am I not correct ?

    Reply
  • HI Pinal

    if i have full database backup size 4gb and i have to restore database to server where available space is less then 4 gb so is there any way to restore database. This question was ask by me in interview.

    Reply
  • Shaun Crawford.
    February 27, 2012 2:54 am

    Hi ShivaR

    I’m currently studying my MCITP course looking to become a Database Administrator. Can I ask how you secured a Trainee Position in particular, as I’m trying to achieve this, I was wondering if you used any sites or contacts in particular.

    Thank you

    Shaun.

    Reply

Leave a Reply

Menu