Author Archives: Andrew Jackson

Resolve Microsoft SQL Server Attach Database Error Code 5120

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

Rate this:

Posted in Sql Server | Tagged , , | Leave a comment

SQL Server Clustering from Command Line

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

Rate this:

Posted in Clustering, Database Administration | 2 Comments

MS SQL Server Transaction Log Architecture

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

Rate this:

Posted in Database Administration, Uncategorized | Leave a comment

Two Ways to Attach SQL Server Database without Transaction Log

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

Rate this:

Posted in Database Administration, System databases | Tagged | 1 Comment