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 […]
Tag: DAC
Using a Dedicated Administrator Connection (DAC) on SQL Server
Using a Dedicated Administrator Connection (DAC) on SQL Server Introduction: Today, I received a call from one of our clients complaining they are not able to login to SQL Server after the recent code deployment. To investigate the problem, I tried to connect to SQL Server remotely using SSMS on my laptop, but my connection also hangs and I’m not...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here