SQL Recovery

SQL Server consists of two essential elements; where “data files” is one and other is “transaction log files.” Transaction log file keeps a log of incomplete transactions of databases. Therefore when SQL Server service shuts down unexpectedly and when user restarts the server again, the read more...

SQL database corruption can make anyone worried, as it stores essential data. Identifying database table corruption can help to resolve the problem in a better manner. This post will discuss the basic symptom of SQL database corruption. You may encounter the following error in SQL Server error read more...

When a user works with MS SQL Server 2005 and creates a report, he may face technical problems. Windows server may restart due to power failure and the user gets a screen prompting for the reason and information for restart of Server. Due to this OS issue, the SQL database becomes read more...

When you try to restore the Microsoft SQL Server database .MDF file from the sequence of transaction log backups, MS SQL Server database gets damaged. In such situations, you might have encountered the following event in the Application Event log of Microsoft SQL Server: “Filestream corruption read more...

DBCC checks the logical and physical consistency of the SQL database and is able to resolve a few detected error messages. However, at times some issues cannot be resolved using the DBCC commands. SQL database corruption majorly occurs due to corrupt metadata, corruptions in certain critical read more...

In MS SQL Server 2000, the replication process usually runs without any issue for more than 377 days. But once these 377 days get over problem arises while accessing the Server. So when the user tries to run the SQL Server 2000 Transaction Replication, he gets an error message: “The read more...

Data files and Transaction log files are the two basic elements in Microsoft SQL Server. All the committed or uncommitted transactions are recorded by or handled by transaction log files. So whenever there is unexpected shutdown of SQL Server, this particular uncommitted log is added to read more...

Clustered indexes are often misunderstood and overlooked in MS SQL Server. Basically, clustered indexes are responsible for overall system performance and maintenance of the database as the size of database increases. Corruption in clustered indexes could land you in trouble as there is a fear read more...

In SQL Server, a database called tempdb is allocated for worktable / #temp table usage. Sometimes when the tempdb exceeds its maximum size limit, it starts behaving in weird manner. Possibilities of database corruption are very high when size of tempdb is larger than it should be, as when size read more...

SQL Server is most preferred server, which is the resident of all the data maintained by your organization, company on day-to-day basis. SQL Server provides an effective way to manage the objects and data within the SQL database. Importing and exporting data in and out of SQL Server is a common read more...