Tagged Questions
3
votes
1answer
128 views
An inconsistency in SQL Server 2008 R2
(could be) possible duplicate with An inconsistency was detected
I have small table that returns from query
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is
...
1
vote
2answers
260 views
Consistency errors for a SharePoint database
When I check my database (SQL Server 2008 R2, Windows Server 2008 R2, SharePoint 2007 DB) with the command:
DBCC CheckDB
I get 12 consistency errors (see below).
Is the only way to fix it with ...
7
votes
2answers
734 views
Msg 2534 : DBCC CHECKDB allocation errors
We recently moved our intranet production database from an SQL Server 2008 to an SQL Server 2008 R2 brand new server.
The backup Job have been failing since migrating, due to DBCC Errors (Check ...
4
votes
4answers
25k views
SQL Server 2008 R2 (Suspect) mode - how to repair?
I have SQL Server 2008 R2 database in Suspect mode. I tried to fix it running this query:
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(’yourDBname’)
ALTER ...
