22 reputation
5
bio website
location
age
visits member for 4 years, 6 months
seen Jan 19 at 19:40

Dec
16
accepted How to run :connect (local)
May
3
awarded  Popular Question
Nov
2
accepted Can't reset sa password
Nov
2
asked Can't reset sa password
Mar
31
accepted DBCC: The database could not be exclusively locked to perform the operation
Mar
30
answered DBCC: The database could not be exclusively locked to perform the operation
Mar
30
comment DBCC: The database could not be exclusively locked to perform the operation
I checked. SQL Server Service runs under windows account which is the local Administrator. It has something to do with user connections. As soon as I kill all connections to a database, DBCC runs fine. I am thinking of creating snapshot and running DBCC on it.
Mar
30
revised DBCC: The database could not be exclusively locked to perform the operation
added 117 characters in body
Mar
29
revised DBCC: The database could not be exclusively locked to perform the operation
added 173 characters in body
Mar
29
comment DBCC: The database could not be exclusively locked to perform the operation
DBCC runs successfully when I kill all connections to the database and then run checks.
Mar
29
comment DBCC: The database could not be exclusively locked to perform the operation
Running with Tablock gives me the same error. Because I still need a short-term exclusive (X) lock on the database.
Mar
29
asked DBCC: The database could not be exclusively locked to perform the operation
Jan
22
comment How to run :connect (local)
The syntax is good, I have to enable cmd mode to execute cmd commands
Jan
20
asked How to run :connect (local)
Dec
22
revised “The requested operation could not be completed due to a file system limitation” 3202
added 159 characters in body
Dec
22
awarded  Scholar
Dec
22
accepted “The requested operation could not be completed due to a file system limitation” 3202
Dec
22
comment “The requested operation could not be completed due to a file system limitation” 3202
The backup over the network is fastest and saves me 3Tb of local disk space :) Thanks for pointing to the memory issue. I left 4Gb to OS and it worked!
Dec
20
awarded  Student
Dec
20
asked “The requested operation could not be completed due to a file system limitation” 3202