What should you always do before creating a new database?
A)backup the master system database
B)install a fresh instance of SQL Server 2012
C)delete all existing temporary databases
D)stop and restart the SQL Server service

Question

Quizplus · Accepted Answer

Backing up the master system database is crucial before creating a new database because the master database contains all the system-level information for the SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. In case of any failure or issue, having a backup of the master database allows for recovery of the SQL Server system to its previous state. The other options are not standard prerequisites for creating a new database.

What Should You Always Do Before Creating a New Database