Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
5
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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
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.
Jan
22
comment How to run :connect (local)
The syntax is good, I have to enable cmd mode to execute cmd commands
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!