If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I found one database failed, I found one user didn't exit the database last night, is that will affect the database backup and integrity check? Another thing, what is integrity check means? How to trouble shoot? Thank you very much! I am a new in sql server.

Gotta love microsoft. Looks like you have a classic generic error message. Could mean "disk is full", or "login failed" or almost anything. Kind of like the engine light in your car. I would start with running

Code:

DBCC Checkdb with no_infomsgs

on all of your databases to see if any of them have suddenly become corrupt. It is unlikely, but it is something you want to know about immediately. The user in the database could be the cause, but I can not say that for certain. Good luck.

Gotta love microsoft. Looks like you have a classic generic error message. Could mean "disk is full", or "login failed" or almost anything. Kind of like the engine light in your car. I would start with running

Code:

DBCC Checkdb with no_infomsgs

on all of your databases to see if any of them have suddenly become corrupt. It is unlikely, but it is something you want to know about immediately. The user in the database could be the cause, but I can not say that for certain. Good luck.

This is AS USUAL for MS Maintenance Plans absolutely useless. Run the DBCC CHECKDB for the database that failed. Don't do it with a maintenance plan. Run it in good old Query Analyzer. Let us know what the error is you get from that, which will hopefully, and usually is, be more informative then gee, you seem to have a problem.

That's like one of our developers who came up to me today and said "Derrick, there's a problem with one of my programs." and then just stood there. "Yeah....SO.....GO AWAY!!!!!"

MeanOldDBA
derrickleggett@hotmail.com
When life gives you a lemon, fire the DBA.

Hi, guys, i was away yesterday, i check today, everything is fine, No any problem, i think the database should be in single user mode. Thank you all.
But i have another question, why one user use sql server database, they have two process ID with same user and database?