Sample Header Ad - 728x90

Dead Raid Card SQL Server Running in Memory

1 vote
1 answer
70 views
Wanted some opinions, on a predicament I’m currently facing. I just got thrown with this mess.. SQL Server database files saving to Raid volume, long story short raid card died so volume is not accessible. SQL service is still running and applications accessing the databases are still responding. The backups aren’t upto date of course. I have tried to export the databases out but error occurs because the files do not exist as the volume isn’t present. However the ram is currently at 47GB. My question is what does SQL Server store in memory, as my understanding is it stores everything in ram and then dumps to file? Is the data recoverable by specialist if I do a raw ram dump? Could I get backup of the database and remount another volume with the same drive letter and file structure and try exporting the database?
Asked by Arsalan (23 rep)
Aug 7, 2018, 06:07 PM
Last activity: Aug 8, 2018, 06:54 AM