Since that is the case, I would now check the server settings and make sure TCP/IP is set on the server.

Excellent article. 

John,

On the client, what protocols are enabled in the SQL Server Client Network Utility?  Is the server aliased in the same utility for a different protocol?

Just some things I would...

I had a problem with one of my installs that had an application running on the box.  I had to disable all the services that the application was running, reboot...

We are about 1/2 way done with our servers and have not had any unexpected outcomes (knock on wood).

Mark - Are you just trying to see how things are going...

Then you need to go into the job that the maintenance plan created and make your modifications there.  Have you made sure that your SQLMail is set up properly under...

That would be when the job is created from the maintenance plan.  There is no place on the maintenance plan itself where you can change this.  If I understand you...

Sufian,

Don't know if you got a satisfactory answer to your question or not. 

If I am reading this correctly, you have a 200 GB log file that you back up...

Adding to Binu John's steps, sometimes I would also need to backup or truncate the log before and after shrinking the file.  For some reason it would not reclaim the...

I've had the same problem when it got hung on an email step.  When this happens, you need to restart the SQL Agent and it will clear it out.

You could also save it as a Structured Storage File and then open it on the new server and save it. 

Did you do a sp_who or look at the Process Info?  Is the restore thread there?  I would guess that there is no active thread for the restore.  I would think...

I would also think you would want to take into account the frequency of maintenance on these indexes.  If you are rebuilding the indexes weekly, you could go with a higher...

Any takers or have I stumped everyone?