SQL Server DBA

SQL Server installation, unattended deployment, startup options, and system database recovery

Question

setup.exe versus sqlservr.exe: which executable serves installation versus recovery startup?

Answer

setup.exe installs, upgrades, patches, or rebuilds system databases. sqlservr.exe is the Database Engine process and accepts recovery startup switches. Use setup.exe for setup actions; run sqlservr.exe directly only for targeted startup, diagnostic, or recovery situations.

This is 15 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples