DBCC CHECKDB is used to check the physical and logical integrity of… Continue reading How to Use DBCC CHECKDB Command for SQL Database Repair?
How SQL Server performs its logging and crash recovery mechanisms till date… Continue reading Microsoft SQL Server Crash Recovery Mechanism
When SQL database stuck in a restoring state, and you try to… Continue reading SQL Database Stuck in Restoring State
In muchas ocasiones, la base de datos de SQL Server entra en… Continue reading Cómo recuperar la base de datos del modo sospechoso
Introduction A common problem is to have the log file corrupt. This… Continue reading How to Reconnect Log File to MDF File
Prerequisites For this backup restoration procedure, we assume that the database backup… Continue reading How to Restore Database Backup in SQL Server 2012
SQL Server operations are highly dependent on the disk subsystem. It is… Continue reading Fix SQL Database Cyclic Redundancy Check (CRC) Error
To prevent data loss and recover a SQL Server database from disaster,… Continue reading How to Perform MS SQL Server Restore with RECOVERY and Restore with NORECOVERY
SYSTEM DOWN: Database Error 8928 and application not working!!!! I woke up… Continue reading SQL Server Production Database Corruption – Causes & Fixes
Introduction I had a colleague who experienced issues attaching a SQL Server… Continue reading Fix SQL Database Error 5173 – Attach database failed for Server
Stellar Repair for MS SQL V9.0 Registration Key is essential to activate… Continue reading How to Get Registration Key of Stellar Repair for MS SQL
It was a sunny day when I was working with the database… Continue reading How to Fix SQL Database Restore Error 5243
Getting started Here are few important points related to backup and restore… Continue reading Right Way to Backup and Restore SQL Server Database
If you’ve accidentally executed a DROP or DELETE command against a table… Continue reading How to Recover Deleted Table Records in SQL Server
The Job role and responsibility of DBA is demanding and Challenging; he… Continue reading Perform Maximum Recovery after SQL Database Corruption
SQL error 924, “Database ‘%.*ls’ is already open and can only have… Continue reading SQL Database Error 924 – Database is already open and can only have one user at a time
Whenever a user establishes a database connection on SQL server, then the… Continue reading SQL Database Error: Cannot Open User Default Database
When trying to back up a SQL database, the backup may fail… Continue reading SQL Server Error 15105 – Unable to Open Physical File
