Thanks Jeff,

My confusion is whether its good practice to reboot the whole server without stopping SQL Server or its ok with the above said steps?

Thanks everyone,

Even i felt the same what Elliot told,but i seriously what to restrict that user to make sure he wont delete a DB.

How can i at least monitor that...

Thanks Lynn..

Thanks Keith,

You are right ,i want to restrict one particular domain user . Need to make that user less privileged.

Editions of SQL Server is not a problem when you do the restore its Version that matters and SQL server don't have backward compatibility.

Thanks Again Gail..

Thanks a lot Gail..

As mentioned in earlier post the solution is to drop and recreate the index and as far as i know its same as Rebuild but Rebuild wont...

Thanks a lot Gail..

Can you please guide me on how to check the IO subsystem?

I think its because it create a snapshot internally

Sure Gail.. Please find CHECKDB Result below

Msg 8951, Level 16, State 1, Line 2

Table error: table 'InvMRF' (ID 911042727). Data row does not have a matching index row in the...

Thanks for the reply..

Please find the unedited result below

Msg 8951, Level 16, State 1, Line 2

Table error: table 'Aspire' (ID 1694329496). Data row does not have a matching index row...

Whats the error you receive when tried to remove the jobs?

Thanks a lot Gail.

Can anyone please help?

Thanks a lot Gail.

As you mentioned I was worried about locking ,blocking or deadlock which may happen because of this and time duration. This one completed very quickly 2secs

For clustered...