Category Archives: System databases

DBA Interview Question# Can we create a snapshot for MSDB system database?

DBA Interview Question# Can we create a snapshot for MSDB system database? Recently I have been approached for one of my technical friend regarding the snapshot for system databases i.e. Master, Model. MSDB & TempDB whether possible or not. As … Continue reading

Rate this:

Posted in Database Administration, Q & A, System databases | Tagged , , , , , , , | 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

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