MSSQL Start/Stop
Stop Instance
Stop Instance
net stop MSSQLSERVER
Normal shutdown
You can also stop a SQL Server instance using SQL Configuration Manager or Services
Offline Database
Offline Database
USE master
GO
ALTER DATABASE [myDB]
SET OFFLINE
GO
To force offline, rolling back any current transactions...
USE master
GO
ALTER DATABASE [myDB]
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
Start Instance
Start Instance
net start MSSQLSERVER
net start MSSQLSERVER /f
net start MSSQLSERVER /m
Normal startup
Minimal Configuration (Safe Mode)
Single-User Mode
You can also start a SQL Server instance using SQL Configuration Manager or Services
Online Database
Online Database
USE master
GO
ALTER DATABASE [myDB]
SET ONLINE
GO
Bibliography
Bibliography