• Privacy Policy
  • Disclaimer
Viral Sant
  • Home
  • Business
  • Tech

    Trending Tags

    • Nintendo Switch
    • CES 2017
    • Playstation 4 Pro
    • Mark Zuckerberg
  • Entertainment
    • Photography
  • Lifestyle
    • All
    • Fashion
    • Health
    Best Gifts for Your Boyfriend

    Best Gifts for Your Boyfriend

    Here's Why You Should Consider Getting a Yoga Teacher Certification

    Here’s Why You Should Consider Getting a Yoga Teacher Certification

    Trending Tags

    • Golden Globes
    • Game of Thrones
    • MotoGP 2017
    • eSports
    • Fashion Week
  • Review
  • Fashion
  • Travel
  • Law
  • Home Improvement
  • Health
  • Gaming
  • Automobile
  • News
    • All
    • Business
    These 7 Tips Will Help You Increase Your Airbnb Revenue

    These 7 Tips Will Help You Increase Your Airbnb Revenue

    What Are The Top Countries That Produce Gem Diamonds

    What Are The Top Countries That Produce Gem Diamonds

    Trending Tags

    • Trump Inauguration
    • United Stated
    • White House
    • Market Stories
    • Election Results
  • Real Estate
  • Social Media
  • SEO
  • Digital Marketing
  • Cryptocurrency
  • How To
  • Electronics
  • Software
  • More
    • Featured
    • Styling
    • Product
    • kitchen
    • Art
    • Celebrity
    • News
    • Science
No Result
View All Result
  • Home
  • Business
  • Tech

    Trending Tags

    • Nintendo Switch
    • CES 2017
    • Playstation 4 Pro
    • Mark Zuckerberg
  • Entertainment
    • Photography
  • Lifestyle
    • All
    • Fashion
    • Health
    Best Gifts for Your Boyfriend

    Best Gifts for Your Boyfriend

    Here's Why You Should Consider Getting a Yoga Teacher Certification

    Here’s Why You Should Consider Getting a Yoga Teacher Certification

    Trending Tags

    • Golden Globes
    • Game of Thrones
    • MotoGP 2017
    • eSports
    • Fashion Week
  • Review
  • Fashion
  • Travel
  • Law
  • Home Improvement
  • Health
  • Gaming
  • Automobile
  • News
    • All
    • Business
    These 7 Tips Will Help You Increase Your Airbnb Revenue

    These 7 Tips Will Help You Increase Your Airbnb Revenue

    What Are The Top Countries That Produce Gem Diamonds

    What Are The Top Countries That Produce Gem Diamonds

    Trending Tags

    • Trump Inauguration
    • United Stated
    • White House
    • Market Stories
    • Election Results
  • Real Estate
  • Social Media
  • SEO
  • Digital Marketing
  • Cryptocurrency
  • How To
  • Electronics
  • Software
  • More
    • Featured
    • Styling
    • Product
    • kitchen
    • Art
    • Celebrity
    • News
    • Science
No Result
View All Result
Viral Sant
No Result
View All Result
Home Tech Solution

4 Steps for Fixing Corrupted database in under 3 Hours

by Admin
January 26, 2022
in Tech Solution
0
4 Steps for Fixing Corrupted database in under 3 Hours
0
SHARES
9
VIEWS
Share on FacebookShare on Twitter

Here I am going to share my experience, how I fixed a corrupt database in under 3 Hours. It is really very much important for any Database Administrator or developer to fix the “Corrupt Database” as soon as possible, which can prevent loss of critical data.

Corruption can happen due to many reasons like disk error, Operating system error, isolation errors etc. Today I faced a New Isolation error while trying to use a newly created SQL Server 2012 instance on a Windows Server 2008 R2. 

Let’s have a look at some common scenarios wherein corruption can take place:

Contents hide
Let’s have a look at some common scenarios wherein corruption can take place:
4 Steps to follows for fixing Corrupted database
Step 1: Recover Accidentally-Deleted Files
Step 2: Fix Corruption in SQL Server Databases
Step 3: Error is thrown while accessing Database1
Step 4: Rebuild Indexes for Corrupt Tables
Conclusion:
  • A user tries opening tables with full-text indexes and receives the following message: “The Microsoft Jet database engine cannot open the file ‘file location’. The file may be corrupt or you may not have permission to access the file. Verify that the path and file name are correct, that you have read permission on the file, then try again.”
  • The below error message is received when users try to use Microsoft Excel 2010 to open an xlsx workbook: “There was an error opening this document”. The range of cells containing the error is displayed.
  • A user tries to attach an .mdf database file for which they no longer have permissions and receives the following message: “Cannot attach the database. You do not have sufficient permission to access this item.”
  • Many times we found corruption issue with SQL Server 2008/2008R2 databases while migrating from Windows XP machines where disk write issues could arise due to older machines and old OS.
  • These all errors occur when we try to access the file, which is corrupted or not present on the disk and the SQL server engine throws an error and stops responding. As a result, users cannot access their data and applications hangs / crash. So let’s see how we can fix these corruptions as soon as possible:

In this article I will show you following steps to recover from “Corrupted Database”: Recover Accidentally-Deleted Files Fix Corruption in SQL Server Databases Recover Damaged Data from Windows NTFS Partitions How to repair Modifications keys in InnoDB tables Rebuild Indexes for Corrupt Tables Reclaim Unused Space by Removing Fragmentation 

4 Steps to follows for fixing Corrupted database

Step 1: Recover Accidentally-Deleted Files 

The first step is to enable the “Show Deleted Objects” option in Object Explorer. Once you’ve done this, right-click on the Database folder and select Restore -> Show Deleted Objects. This will show all the objects that have been marked for deletion but not yet removed by a garbage collection process. Now restore these files or delete them back to recover your accidentally deleted files. For more information about the Restore command please follow http://technet.microsoft.com/en-us/library/ms178068 (v=sql.105).aspx

Step 2: Fix Corruption in SQL Server Databases 

Many times corrupted databases are caused due to transaction logs overflowing or truncation errors. In the below example I have a database called “Database1” which was throwing errors 

Step 3: Error is thrown while accessing Database1

In order to fix this issue, I need to stop the SQL Server service, delete all the Transactions logs from the specified path. Once deleted, start the SQL Server services back and now try to access your DB. By following these steps only we can resolve corruption issues with our databases very quickly without any data loss.

The health of Database1 is Normal after fixing Corruption issues

All tables are accessible successfully

Step 4: Rebuild Indexes for Corrupt Tables 

The third step will be rebuilding indexes for corrupt tables. If you delete any rows from a table and re-create an index, or rebuild the index, the structure of the index will be different than it was before. Re-creating or rebuilding an index does not recreate all columns in each leaf level of the index. 

Conclusion:

In order to fix corruption issues in SQL Server databases, I would recommend you to follow all 4 steps in the above article and recover your data in no time. Corruption is a common issue that occurs with SQL Server Databases and we need to take care of this issue immediately so that we can avoid causing any major harm to our system/data. These are some quick recovery steps but for complete recovery, we will need professional help or better go for third-party tools such as Stellar Phoenix SQL Recovery.

Tags: Corrupt TablesCorrupted databaseSQL RecoverySQL Server databasessystem error
Previous Post

Political cartoon of the day: Two-Front War

Next Post

Fox News footage shows mass release of single adult migrants into US

Admin

Admin

We at Viral Sant bring you the latest news and updates about everything happening around us.

Related Posts

How To Make Digital Flyers in Canva
Marketing

How To Make Digital Flyers in Canva

by Admin
October 18, 2022
Online Will: How It Works And How To Make One
Law

Online Will: How It Works And How To Make One

by Admin
September 27, 2022
How to use MAC Address Lookup - Unique address for each network
How To

How to use MAC Address Lookup – Unique address for each network

by Admin
June 6, 2022
What Are The Best Freely Available IP Lookup Sites?
Tech Solution

What Are The Best Freely Available IP Lookup Sites?

by Admin
June 3, 2022
Visual Shopping: Tips For Preparing Your Ecommerce Images
Tech Solution

Visual Shopping: Tips For Preparing Your Ecommerce Images

by Admin
March 30, 2022
5 Best Free Tools with All Essential Functionality to Carry Out Database Recovery Operations
Tech Solution

5 Best Free Tools with All Essential Functionality to Carry Out Database Recovery Operations

by Admin
January 26, 2022
Next Post

Fox News footage shows mass release of single adult migrants into US

5 Best Free Tools with All Essential Functionality to Carry Out Database Recovery Operations

5 Best Free Tools with All Essential Functionality to Carry Out Database Recovery Operations

6 US fighter jets arrive in Estonia amid Ukraine tensions

Justice Breyer long known for high-court 'hypotheticals'

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Stay Connected test

  • 23.7k Followers
  • 99 Subscribers
  • Trending
  • Comments
  • Latest
AnimeUltima : Most Popular Anime Online Website

AnimeUltima : Most Popular Anime Online Website in 2022

March 4, 2022
FreeAllMusic : Listen to your Favourite Music for Free and Know Everything About it

FreeAllMusic : Listen to your Favourite Music for Free and Know Everything About it

November 19, 2021
Mia Melano Height, Age, and Other Information

Mia Melano Wiki, Height, Age, Professional and Personal Life

December 16, 2021
GenYoutube ( Gen यूट्यूब) | Downlaod Youtube Videos, Songs,Photos for free in 2022

GenYoutube ( Gen यूट्यूब) 2022 | Downlaod Youtube Videos, Songs,Photos for free

September 27, 2022
Vitamin C for Skin Health

What are the Benefits of Using Vitamin C for Skin Health?

0
Cheap 5G Mobiles

Know Why Buying Cheap 5G Mobiles is not a Good idea

0
6 Best Grilling Hacks

6 Best Grilling Hacks That Will Make You Look Like a Chef

0
technical SEO strategies

5 Important Technical SEO Strategies in 2021

0
Proceeding with Life After an Accident

Proceeding with Life After an Accident

December 19, 2022
These 7 Tips Will Help You Increase Your Airbnb Revenue

These 7 Tips Will Help You Increase Your Airbnb Revenue

December 5, 2022
What Are The Top Countries That Produce Gem Diamonds

What Are The Top Countries That Produce Gem Diamonds

December 5, 2022
Best Gifts for Your Boyfriend

Best Gifts for Your Boyfriend

December 5, 2022

Recent News

Proceeding with Life After an Accident

Proceeding with Life After an Accident

December 19, 2022
These 7 Tips Will Help You Increase Your Airbnb Revenue

These 7 Tips Will Help You Increase Your Airbnb Revenue

December 5, 2022
What Are The Top Countries That Produce Gem Diamonds

What Are The Top Countries That Produce Gem Diamonds

December 5, 2022
Best Gifts for Your Boyfriend

Best Gifts for Your Boyfriend

December 5, 2022
Viral Sant

We at Viral Sant bring you the latest news and updates about everything happening around us. Our aim is to provide informative and correct knowledge to our readers and make our name in words top News Magazine.

Email: [email protected]

Follow Us

Browse by Category

  • Art
  • Automobile
  • Business
  • CBD
  • Celebrity
  • Cryptocurrency
  • Digital Marketing
  • Education
  • Electronics
  • Fashion
  • Finance
  • Health
  • Home Improvement
  • How To
  • kitchen
  • Law
  • Lifestyle
  • Marketing
  • Outdoor
  • Pet
  • Product
  • Real Estate
  • SEO
  • Social Media
  • Software
  • Tech Solution
  • Uncategorized

Contact Us

    • About
    • Advertise
    • Privacy & Policy
    • Contact

    © 2023 Viral Sant. All Rights Reserved

    No Result
    View All Result
    • Home
    • Business
    • Tech
    • Entertainment
      • Photography
    • Lifestyle
    • Review
    • Fashion
    • Travel
    • Law
    • Home Improvement
    • Health
    • Gaming
    • Automobile
    • News
    • Real Estate
    • Social Media
    • SEO
    • Digital Marketing
    • Cryptocurrency
    • How To
    • Electronics
    • Software
    • More
      • Featured
      • Styling
      • Product
      • kitchen
      • Art
      • Celebrity
      • News
      • Science

    © 2023 Viral Sant. All Rights Reserved