Thursday, March 28, 2024

Stellar Repair for MS SQL – Software Review

When restarting an SQL Server, the SQL databases undergo recovery. The databases cannot be accessed unless the recovery is complete. However, at times, you may find the database stuck ‘In Recovery mode’ for a long time. In this post, I will share my experience about encountering the SQL database stuck in ‘Recovery mode’ issue and how I restored my database by using Stellar Repair for MS SQL software.

Problem Scenario

Last week after SQL server restart, the SQL database went in recovery mode. I waited for the recovery process to finish; however, the database has been stuck “In Recovery” mode for a long time. This is preventing the database from coming online, and users cannot access the database. I need to bring the database back online.

What did I do to Perform Restore the SQL Database?

I checked the SQL Errorlog, and it showed a message specifying that the database is still in recovery mode. The last message in the errorlog says ‘2 189 255 seconds remaining (Phase 2 of 3)’ which is almost 25 days. 

I googled the message displayed in the SQL errorlog and found that the issue could be caused due to the long-running transaction. Several posts suggested waiting for the database recovery process to complete. However, it’s already been several days, and the database remained in recovery mode. And, I could not spend more days on recovery, as the pressure to restore the database to normal mode was building up. I then searched for a quick fix to restore the SQL database to normal mode.

I tried bringing the database online by using a â€˜RESTORE…WITH RECOVERY’ command. However, it put the database through the same steps. I decided to opt for a professional SQL repair tool that could help to quickly and efficiently restore my SQL database to its original state. This was when I came across Stellar Repair for MS SQL software. After reading MVP reviews about the software, I decided to give it a try.

How Stellar Repair for MS SQL Software Works?

The SQL Recovery software requires the following minimal specifications to be met before running it on a PC:

Processor: Intel-compatible (x86, x64)

RAM: 4 GB (8 GB recommended)

Free Space: 250 MB

OS: Windows 10/ 8.1/8.0/7/Vista/Windows Server 2012/2008/2003

Downloading and installing the software takes only a few minutes. Once installed, run the software and follow these steps to restore the SQL database:

Step 1: A message will prompt asking you to stop your SQL Server and copy the db to a different location. Restart the server and proceed with repairing the database copy. Click OK.

From the software main screen, browse the MDF database file you want to repair from the ‘Select Database’ window.

Note: Use the ‘Search’ option to locate the MDF file if the file location is not known to you. 

Step 2: After selecting the file, click the ‘Repair’ button and select the appropriate ‘Standard Scan’ or ‘Advanced Scan’ mode. Click ‘OK’ to initiate the repair process.

Note: Choose the ‘Advanced Scan’ mode to repair severely corrupted SQL database files. 

Step 3: Click ‘OK’ when the ‘Selected MS SQL database repaired successfully’ message appears.

Note: The software might fail to detect the file version of a severely corrupt SQL database file. In that case, you must select your database version manually from the window that appears as shown below:

Step 4: After successful completion of the repair process, the software displays a preview of recoverable database objects. 

Step 5: Select all or specific database objects that you want to retrieve from the repaired database (.mdf) file in the preview window. Click ‘Select Database’ on the File menu to save the selected, repaired, and recovered data.

Step 6: In the ‘Save Database’ window, do the following:

  1. Select ‘MDF’ as ‘Save As’ option 
  2. Save the repaired file in ‘New database’ or ‘Live database.’ 
  3. Enter the required details to connect to SQL server.
  4. Select the location to save the repaired MDF file.
  5. Click ‘Save’.

After performing these

Website

Latest articles

2 Chrome Zero-Days Exploited at Pwn2Own 2024: Patch Now

Google has announced a crucial update to its Chrome browser, addressing several vulnerabilities, including...

The Moon Malware Hacked 6,000 ASUS Routers in 72hours to Use for Proxy

Black Lotus Labs discovered a multi-year campaign by TheMoon malware targeting vulnerable routers and...

Hackers Actively Exploiting Ray AI Framework Flaw to Hack Thousands of Servers

A critical vulnerability in Ray, an open-source AI framework that is widely utilized across...

Chinese Hackers Attacking Southeast Asian Nations With Malware Packages

Cybersecurity researchers at Unit 42 have uncovered a sophisticated cyberespionage campaign orchestrated by two...

CISA Warns of Hackers Exploiting Microsoft SharePoint Server Vulnerability

Cybersecurity and Infrastructure Security Agency (CISA) has warned about a critical vulnerability in Microsoft...

Microsoft Expands Edge Bounty Program to Include WebView2!

Microsoft announced that Microsoft Edge WebView2 eligibility and specific out-of-scope information are now included...

Beware of Free Android VPN Apps that Turn Your Device into Proxies

Cybersecurity experts have uncovered a cluster of Android VPN applications that covertly transform user...

Mitigating Vulnerability Types & 0-day Threats

Mitigating Vulnerability & 0-day Threats

Alert Fatigue that helps no one as security teams need to triage 100s of vulnerabilities.

  • The problem of vulnerability fatigue today
  • Difference between CVSS-specific vulnerability vs risk-based vulnerability
  • Evaluating vulnerabilities based on the business impact/risk
  • Automation to reduce alert fatigue and enhance security posture significantly

Related Articles