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…
-
-
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…
-
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. =======================make sure you got the following information, see the example in the bottom DB size – Sp_helpdb ‘Dbname’ – 80 GB Source DB latest backup date and availability – Check the backup history and check backup is available in drive – Yes Destination DB latest backup date and availability – Optional (latest backup available ) Can we overwrite destination with or without backup – Check with the requester – Yes, overwrite take a backup before ======================= Why I choose the T-SQL…