Data Corruption is bad. Corruption either occur physically or logically in indexes. The Non-clustered Indexes are pointers of data that helps you in finding data more quickly. It contains Non-clustered key value and each key value has a pointer that … Continue reading
Sometimes when connecting to the database, the database becomes inaccessible and you will get the following error message: The error message indicates that the database is in SUSPECT mode.
When the users try to attach a database to SQL server then sometimes it becomes difficult to do this due an error. This error is known as Microsoft SQL Server error 5120 access denied. The error message occurs on the … Continue reading
Introduction In this tutorial I will show you few command line options to manage a SQL Cluster status as well as for falling over. Need of Command Line The graphical tool works great, but what can you do when your … Continue reading
SQL Server Transaction Log files are the inherent part of every Microsoft SQL Server files, Also known as database log, transaction journal, binary log file etc. A transaction log contains history of all the activities executed in database. From disaster … Continue reading
Procedure to Attach Database without Transaction Log A few days back one of my colleagues contacted me in order to restore a SQL database on the server. The colleague was in possession of a MDF file, but unfortunately did not … Continue reading