-
March towards SQL Server : Day 16 – SQL DBA Interview Questions Answers – Database Mirroring – 2
Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What is Database Snapshot? A database snapshot is a view of what the source database looked like at the time at which the snapshot was created. This means that all the objects will…
-
March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1
Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will cover this topic in two blogs so that I can touch base all the possible Questions from Database Mirroring. 1. What is Database Mirroring? Database mirroring was…
-
Common Human Errors as DBA (part 2)
You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error – Data or Log file Shrinking – sometimes, one may not be checking how much free space is available in data or log files and shrinking databases…