Creating CSV Files Using BCP and Stored Procedures
Backup & Restore from Command line
Single User Mode

This allows you to restore the master database, and also add the windows local administrator to add user with whatever rights necessary. e.g. sysadmin for local admin

  • Stop SQL Service
  • Start command window 'run as an administrator'.
  • Change to the the required Folder for sqlservr.exe , e.g. C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
  • Run below command
"sqlservr.exe -c -m"

How to tell what version of SQL you are running is (Standard / Express etc.)

select @@servername
select @@version
select serverproperty('edition')