Category Archives: System databases

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

MS SQL Server System Databases

There are four visible system databases and one is hidden system database. Visible Databases: Master Model MSDB TempDB Hidden Database: Resource Database All system databases are important and play a distinct role, the description is as below: Master Database: The┬ámaster┬ádatabase … Continue reading

Rate this:

Posted in Database Administration, System databases | Tagged , , , , , , , , | Leave a comment