Tag: rebuild master db

SQL Server

SQL Server recovery procedures for a catastrophic failure – (Part-2)

SQL Server recovery procedures for a catastrophic failure – (Part-2) Author: Basit A. Farooq To rebuild master follow the instructions below: Execute Setup.exe as follows: start /wait setup.exe /qn INSTANCENAME=instance_name REINSTALL = SQL_Engine REBUILDDATABASE=1 SAPWD=strongpassword Setup recreates the resource database and the master database. Install any necessary service packs. Attach any user databases or restore databases from backup. If the […]