• Backup/Restore,  DBA

    SQL server Database backup restores Steps

    SQL server Database restores sequence Steps I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN… I got a comment from Anonymous user. It’s a simple task to the experienced DBAs. However it’s very important to know the database restoration sequence. It’ll help number of situations. For example, Your database got damaged in any one of the reasons. (Or) You may get a request from the DEV team to restore a database from production to development. I have already written an article about Step by step backup/restore using T-SQL. But it’s not fully focus the restoration sequence. Here I…

  • Backup/Restore,  Basics for freshers,  Internals

    SQL server Recovery Models and Backup types

    In this post I am going to explain the importance of recovery models and backup types. Why I am writing this post ? Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some examples and cleared his doubts. I am going to share this with you guys too. I hope this will help for Freshers and DBA managers. Recovery models and backup types are important to plan the recovery point objective (RPO) and recovery time objective (RTO). We can’t differentiate the recovery models and backup types. Simply, it’s a mixture. Let’s see the discussion. Manager: We need minimum data…

  • Backup/Restore

    Step by step backup/restore using T-SQL

      This article mainly for SQL server learners, who is going to become a DBA, in this article I am going to explain the backup and restore using T-SQL. Why I choose the T-SQL instead of GUI? Below are reasons, I have seen a number of articles and blogs shows the GUI. Anyone can use the GUI to restore the database, if they don’t well in SQL. Again most of the DBAs hasn’t used the command and they don’t know the T-SQL syntax to restore the database. I recommend using the T-SQL to restore the database because it’s the greatest tool when you are migrating a huge number of databases (Not…