Repair MSSQL Databases
Show Posts in
How to Reorganize and Rebuild Indexes in SQL Server Database?
Priyanka Chauhan
May 25, 2022
File Repair
Repair MSSQL Databases
In an MS-SQL Server database, the data is stored in pages where each page is 8 KB wide and 8 contiguous pages form an extent. The following image shows how the pages are linked together via a B-tree index structure. A B-tree index structure (where...
5 Crucial SQL Server Database Backup Best Practices
Charanjeet Kaur
April 21, 2022
File Repair
Repair MSSQL Databases
Backing up a SQL Server database is not enough. You need to also ensure that you can restore the database from backup, quickly and efficiently. However, it is commonly seen that backups fail at the time of restoring. According to an online survey, “5...
-645.jpg)
Database is Being Recovered, Waiting Until Recovery is Finished
Charanjeet Kaur
March 08, 2022
File Repair
Repair MSSQL Databases
Table of ContentsWhen SQL Server Database Goes into Recovery What to Do Next Causes behind the Error and Solutions Thereof Alternative Solution FAQs When SQL Server Database Goes into Recovery When SQL Server starts crash recovery...
-622.jpg)
How to Plan for Corruption Check for SQL Server Databases?
Charanjeet Kaur
January 05, 2022
File Repair
Repair MSSQL Databases
Table of Contents Planning for Corruption Check for SQL Server Databases” Enable CHECKSUM for Database Pages Run Backup Command with Checksum Use TABLOCK Hint to Run DBCC CHECKDB without Error Run Script to Check SQL Databases for Fatal Cor...
How to Recover SQL Database after RAID Failure?
Charanjeet Kaur
November 19, 2021
File Repair
Repair MSSQL Databases
When a SQL Server database is configured on RAID, failure of the RAID drives can corrupt the data and lock you out of the database. In such a situation, you must replace the failed drives and try to rebuild the RAID array, and restore the database fr...
Recover SQL Databases Affected from STOP/DJVU Ransomware
Charanjeet Kaur
September 09, 2021
File Repair
Repair MSSQL Databases
STOP/DJVU is one of the most widely spread ransomware that has reportedly affected thousands of victims all over the world. It spreads through keygens, cracked applications, fake application setup, fake Windows updates, and malicious email attachment...
-535.jpg)
How to Restore Database from Snapshot in SQL Server?
Charanjeet Kaur
August 16, 2021
File Repair
Repair MSSQL Databases
Understanding Database Snapshots Reasons for Restoring Database from Snapshot in SQL Server Demonstrating an Example to Restore Database from Snapshot in SQL Server...
SQL Database States – All You Need to Know
Charanjeet Kaur
July 21, 2021
File Repair
Repair MSSQL Databases
Table of Contents 1. How to Check SQL Database State? 2. Types of SQL Server Database States 2.1 ONLINE 2.2 OFFLINE 2.3 RESTORING 2.4 &nbs...
How to Restore a SQL Server Database Backup to an Older Version of SQL Server
Charanjeet Kaur
July 18, 2021
File Repair
Repair MSSQL Databases
SQL Server doesn’t allow taking a database backup from a higher version and restoring it to a lower version. And, you would likely encounter the following error when trying to downgrade a database to an older version of SQL Server:Here, the error mes...
How to Repair SQL Server 2016 Step by Step
Charanjeet Kaur
June 24, 2021
File Repair
Repair MSSQL Databases
You might need to perform SQL database repair operation in the following scenarios:Repair a database that is marked as suspect or stuck in recovery pending state, preventing you from accessing the database files.Repair a database that has turned corr...
Load More