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

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!