Just to chime in ... got the error twice yesterday and once today ...

I took the extract below from thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=202884

Here's how:

I've had this problen quite frequently lately (ughh...)

First thing you need to do is download the setspn utility (link...

Are you configured to run SQL Mail ? If so then the 'profile' for SQL Mail may be corrupt or might have been deleted ...

Are you running the backup from a maintenance plan ? If you are not using a maintenance plan, is the Job executed via the SQL Agent ? If it is...

Check out the following links for a start ...

http://www.emc.com/

http://www.hds.com/pdf/wp_149_san_nas_convergence.pdf

By the way a SAN is not a cheap venture ... a 1 cabinet Hitachi with a few terrabytes of...

The solution posted is a good start, but I would not rely on ping alone ... The OS could be alive and SQL Server down is one sitiation I've seen...

What type of error are you receiving (e.g. 42000 login failed - usually bad username/password) Can you ping the SQL server ? Can you perform a telnet to port 1433...

Just a couple of other points to factor in ... did you perform the database backup to disk or directly to tape ? Will the restore be from disk or...

What OS/SP are you running ? What SQL Version/SP are you running ? Is the error occurring on the SQL Server itself ? Is the error occurring on a client...

I am going to, ughhh, assume, that your present server is sized correclty and performing well. In an ideal world your devlelopment server would mirror your production server (cost and...

Do you run sp_ecompile for the table as well ? If not then the optimizer is still using the old execution plan,

Collation affects alot of things ... some of the more notable things, order by and group by clauses (resultant query data may appear in a different order). You can change...

Let me take a wild guess ... you have taken and are presently executing the installation defaults for SQL Server, Analysis Server ... on multi-use and/or heavily hit servers this...

What is your network connectivity ? The reason I ask is that I have been in a similar situation once before. The only things you may be able to do...

What is your network connectivity ? The reason I ask is that I have been in a similar situation once before. The only things you may be able to do...