Thanks for your reply. I was littlebit worried as this database is not much large, but it's already a day since I am running this process...It's really taking so long....The...

The Database size is 320 GB. I have started to run DBCC Checkdb on that database yesterday. It is running since 20 hours....Any idea why it is taking so long...

I have an issue while i take backup of database...whether I take it on one drive, another drive or another server or another Tape drive...I am getting same error...Any insight...

Here's issue. I am not able to backup that corrupted database. This is the error it gives...

BackupIoRequest::WaitForIoCompletion: read failure on backup device 'E:\Data\abc.mdf'. Operating system error 23(Data error (cyclic redundancy...

no i am not putting xp_sendmail in a job step...my question is that when I run xp_sendmail seperately it sends me the email...but when i run job and if it...

I am refering to sql 2000

Hi All,

I got the problem..Actually when I went to my computer and rightclick and goto manage and goto disk management...I was only able to see C:...

master dbs are on the same drive...

I have also tried using local system account...but same problem

Please let me know asap...thanks all

Thanks a lot Manu....That really worked..

Thanks for your reply.

But here's the problem. For some databases we are doing differential backups through scripts not with the maintenance plan and those dbs...

Still We have this problem.. Please reply.

By the way, can anyone How to setup dependencies from cluster manager?

Also to clarify again, We put Data drive(D: ),trans log drive(E: ) and...

Thanks for the link. Can we setup the number of attempt the user can make before he get locked out from there?

Go to that server->control pannel->Administrative tools->Event viewer->system logs...You can get all the information like who stopped and started the service (see the records with "source" column = service control manager),what...

Please refer to following link...I used this bol documentation to install sql server cluster...This also mentions how to do failover and other imp. sql server cluster administration stuffs.

http://msdn.microsoft.com/en-us/library/ms190990(SQL.90).aspx

Is there any way to give different paths for data and Trans.log files while we install sql server????????