This is the output for the DBCC checkdb command

I executed DBCC checkdb (db_name) with all_errormsgs;

Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further...

Am unable to do DBCC checkdb also.

It is erroring with temp db out of space.

Month back , i tried to run dbcc when my application was down. That...

Hi All,

I stopped my SQL server agent job and restored the MSDB from a good backup. I performed DBCC check after the restoration, it returned 0 allocation errors and 0...

Thank you all 🙂

I shall restore the database and check.

Will keep posted.

Thanks,

Dev.

In that case I need not take an outage, it is just the scheduled jobs will get affected during the restoration.

I should take the SQL Server in single user mode for restoring the system databases. Could you please confirm

Hi,

I have a practice to backup the system databases. Shall i go ahead and restore the Oct 23rd backup, that is before the server refresh.

Could you please let me know...

Server team did the server refresh and I was coordinating from the database end.

Since there was some issue with index, I planned to restore the database. There is no...

Hi,

Please find the DBCC output ran with NO_INFOMSGS.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type...

Hi,

Please find the hardware details below

IBM XSERIES_3650 Intel® Xeon™ MVcpu 3.20Ghz, RAM:8GB

We are taking backup to H: drive whose free space is around 157 GB.

Initially all the application jobs running on the server got failed, because of IO issue. So admin recommended to increase the virtual memory.

When the backup was in ASYNC IO, it...

Yeah, previous week it took 3 hrs and it did not complete. After increasing the virtual memory, it took 45 mins to backup the 82 gb database, though it was...

Thanks Lowell. I will check with him and post the thing what has been blocking.

Thanks again,

Devanand.

In addition to the last reply I just want to tell that I changed the SMTP authentication to Anonyms but i didn't worked.

This is the error msg I am getting "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-08-06T05:26:52). Exception...