Add –m in the sql server start up parameter to start SQL Server in Single User Mode.
Make sure you stop sql agent otherwise, sql agent will take the only connection right away.
Subscribe to:
Post Comments (Atom)
Translate
Search this blog
About me
Labels
ADDM
(2)
ADR
(1)
adrci
(1)
ASH
(1)
ASM
(8)
AWR
(4)
AWS
(4)
Azure
(8)
BACKUP_RESTORE
(6)
BOOK
(2)
Certification
(2)
Cloud
(7)
ColumnStore
(1)
constraint
(1)
Contained Database
(1)
CTE
(1)
Cursor
(1)
Data Buffer Cache
(1)
Data Model
(1)
Data Recovery Advisor
(1)
Database Link
(3)
Database Replay
(1)
DATABASE_ALERT
(1)
DatabaseMail
(3)
DataStudio
(2)
DB2
(27)
DB2 10.5
(4)
DBCC
(6)
DBcompare
(1)
DMV
(5)
DQS
(1)
DSDE
(3)
ERwin
(1)
Event
(3)
Greenplum
(1)
GRID
(6)
HADR
(7)
Hardware
(4)
HIgh Availability
(2)
Hyper-V
(7)
index
(2)
InMemoryOLTP
(7)
Installation
(1)
ISOLATION
(1)
kerberos
(2)
Learning Resource
(1)
Linux
(29)
Listener
(2)
Log
(6)
MDS
(1)
MDW
(1)
Memory Management
(27)
MongoDB
(2)
MSSQL
(115)
MSSQL 2008
(51)
MSSQL 2012
(14)
MSSQL 2014
(27)
Networking
(3)
NoSQL
(2)
NUMA
(3)
OEM
(8)
Oracle
(135)
Oracle File
(17)
Oracle Resource Manager
(3)
Oracle Stream
(2)
Oracle12c
(1)
partition
(2)
Performance Tuning
(28)
php
(1)
PL/SQL
(3)
PostgreSQL
(4)
PowerShell
(7)
RAC
(5)
Resource
(3)
Resource_Governor
(1)
SAMPLE DB
(1)
Security
(21)
SGA
(10)
SHARED_POOL
(5)
SQL
(11)
SQL*Plus
(2)
SQLagent
(1)
sqlite
(1)
SSDT
(1)
SSMS
(3)
Starbucks
(1)
Storage
(19)
Storage Engine
(4)
Sybase
(2)
T-SQL
(19)
TableSpace
(11)
TDE
(1)
tempdb
(13)
Teradata
(1)
Tool Box
(33)
trace
(2)
TroubleShooting
(48)
UserAdmin
(8)
Vargant
(1)
Virtual Box
(9)
Virtualization
(11)
VMWare
(9)
vNext
(1)
windbg
(4)
Windows Server 2012
(1)
Windows8
(1)
WinServer 2012
(1)
WinServer2008
(23)
Popular posts
-
Time to time I have the need to simulate the workload for different reasons, such as exercise the SQL Server P/T, knowing how much load the ... -
From Oracle 10g, Oracle has introduce many advisors to assist DBA maintenance work. From the DBA_ADVISOR_DEFINITIONS table, we can get som... -
While Install the Oracle Grid infrastructure, I got CRS 4124 error as below: CRS-4124: Oracle High Availability Services startup faile... -
When I try to connect to my Oracle RAC test environment via SCAN name with SQL Developer, I got the error “ORA-12505, TNS:listener does not ... -
During creation the Availability group in SQL 2014, I have encounter the below error when try to add the 2nd replica. The specified inst... -
Java Pool store the session specific code within JVM . How to check the Java Pool size? show parameter java_pool select * from ... -
Just like most of the Windows software, SQL Server is operating under thread model. This means the SQL Server process would spawn child thre... -
prerequisite Windows Server 2012 Download 12c from Oracle There are 2 files download from Oracle. We have to extract them a... -
Start up/Shutdown The OEM 12c is startup/shutdown by unlockgcstartup and gcstartup. Manually start/shutdown OEM 12c – OMS( Oracle Mana... -
If you get the error while trying to post blog from windows live writer to Google Blogger service and get the login error: or Windows ...
My Starbucks CityMug
Total Views ( Last 30 Days)
Follow by Email
SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates
Find trendy technology stock photos in HD and tens of millions of different royalty-loose stock photographs, illustrations and vectors within the Shutterstock series.
ReplyDeleteRandom Email Generator
Black light app
Temp mail
Terrarium TV App
tik tok
ERP software