Repair Corrupt SQL Server Database

!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } --> In this blog post, I will try to explain all possible steps that you will have required to repair your corrupt SQL server database. Let's consider a case where you are working on SQL server database, trying to access some records from a table. During table access process you have got an error message that specifies, you can't access desired table due to database corruption. Corruption in SQL server tables can happen due...

Read More

Causes & Resolutions for MS SQL Server Error 5120

!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } --> Are you getting SQL server error 5120, when you try to attach some database files to Microsoft SQL server? This may happen because you have selected a file that is in use by other SQL server instance or selected a wrong file for the attachment. To fix this, firstly you have to check the location and status of SQL server files that you want to attach. The default location of data & log files are: C:Program-files\MSSQL\Data\Database-Name_Data1.mdf C:Program-files\MSSQL\Data\Database-Name_Log1.ldf Note:...

Read More