LaravelCode

Search

Fix recovery pending state in SQL server database

MySql
1782 views 2 years ago
post-title

When you can't access one or multiple file access to SQL server, there may be issue SQL server is corrupted.

The error may be due to:

  • The database couldn't be shut down properly.
  • Due to insufficient space or hard disk space.
  • If the primary database files are corrupted, the user will face this problem.
  • It may be when you change the state from offline to online.

In this article, I will show you how to fix recovery pending state in SQL server. Follow bellow steps to resolve SQL server database issue.

Open SQL command line and run the below query one by one to resolve it.

ALTER DATABASE db_name SET EMERGENCY;

ALTER DATABASE db_name set single_user;

DBCC CHECKDB (db_name, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;

ALTER DATABASE db_name set multi_user;

Now refresh the database and you will see the error is fixed. I hope you liked this article.

Random Articles
  • How to Change the Text of a Button using jQuery
    Use the jQuery prop() and html() Methods You can simply use the jQuery prop() method to change the text of the buttons built using the HTML <input> ele...
  • How to remove elements from DOM in jQuery
    Use the jQuery remove() method You can simply use the jQuery remove() method to remove the elements from DOM. This method will remove the matched elements as well as everything inside of it. The...
  • How to Install Oh My Zsh in Ubuntu
    Your terminal never felt this good before. Sometimes you are getting bored with one desktop environment, for example Unity or Gnome. So what you do is install new desktop environment and apply for...
  • How to Create Custom Maintenance Page in Laravel 7.x Example
    In this article, I will apportion you simple way to put your Laravel website in a maintenance mode with a custom page. For what purport? Sometime we might need to upgrade the website or might have...
  • Redux Mastery: A Practical Guide Through a Mini-Project
    Introduction Redux is a powerful library for managing the state of your JavaScript applications. It follows a unidirectional data flow pattern, making it easier to manage the state, especially in com...
Advertise