RSS

Tag Archives: Stellar Data Recovery

Recover Data lose with fixing corrupted DB

Introduction

While working on the production environment, we as database administrators are exposed to unforeseen problems associated to our SQL Server. This may lead to the crucial data loss, in case we don’t have updated backup solution. Such situations are not less than the nightmare for DBA’s when recovery of the complete data becomes their utmost responsibility

Problem

I will show here two corrupted issues one in normal DB and another one in DB with MEMORY_OPTIMIZED_DATA filegroup

the suspect mode is one of the common issues that can lead us for data loss and in my case I don’t have a backup for this DB, and I am committed to returning the DB online without any data loss after more research and investigation I tested two solutions

Read the rest of this entry »

 
Leave a comment

Posted by on June 17, 2018 in DB corruption

 

Tags: , , , , ,