SQL Server - Is there any way to recover a corrupted database without backup?

Daredevil

I am simulating a database corruption for my own practice. What I did was editing the .LDF file and messing it up and when I run SQL server, the database is in "Recovery Pending" mode, meaning it has been corrupted.

Without any backup to be restored or without replacing the backup .LDF file, is there any way I could recover my database?

Note: I am not interested in using any third party tools/software.

Would appreciate any suggestion.

MartinS

Try to use these commands on the master database. It will reset the state of the database so you can work with it. This will put it into SINGLE USER MODE and ROLLBACK pending changes. After repair it will allow MULTIUSER AGAIN.

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-12-1

Comments

0 comments

I have a backup of the Wordpress folder but not the SQL database, is it possible for me to recover the website for local use?

Is there any possible way to restore database with only merge or insert options instead of deleting or replacing data (SQL Server 2014)

Insert records from one table to another without violating any constraint in SQL Server database

SQL Server - RESTORE database with different name Fails - "The backup set holds a backup of a database other than the existing"

Once a wide variety of spammers have an email address is there any way to recover it without using aggressive spam filtering

TOP Ranking

Article

SQL Server - Is there any way to recover a corrupted database without backup?

SQL Server - Is there any way to recover a corrupted database without backup?

pump.io port in URL

grouping by column variables and appending a new variable based on condition

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

Group boxplot data while keeping their individual X axis labels in ggplot2 in R

Vector input in shiny R and then use it

BigQuery - concatenate ignoring NULL

Can a 32-bit antivirus program protect you from 64-bit threats

How to remove the extra space from right in a webview?

How to how increase/decrease compared to adjacent cell

android.content.Context.getSharedPreferences(java.lang.String, int)' on a null object reference id DBhandler

Getting 502 Bad Gateway Error While Deploying WordPress On Dockerized Lemp?

Type 'number' is not assignable to type 'NgIterable<any>' when trying to async observe a datasource

Check if a number is a perfect square

FFmpeg resize without upscaling

How do I display Label text character-by-character?

How to show an image in a View with ASP.NET MVC 5? (Many suggestions failed so far)

Json Schema - Conditional Evaluation with RegEx

PlayOnLinux displays weird looking window on 18.04 for MS Office installation

JMeter: Why get error when try to save test plan

Emulator wrong screen resolution in Android Studio 1.3