There is nothing in the SQL Server error log.    Is there an upgrade log?

is the second SQL Server in your SQL Server box hosts file?  If not add it

Eric

Thanks, that is exactly what I was looking for

Eric  

Excellent

This works better!

Thanks

Eric

Thank You Mr Grizzly Bear, it works great

Now I just have to re-train my fingers to type it....

Thanks Again

Eric 

It is really easy once you have done it once or twice

1. from enterprise manager, select the database and mene to all tasks/restore database option
2. On the Restore Database popup, select the "from...

One more thing.....

Check your HOSTS file.    If your not going directly against an IP address, this can be an issue.

The HOSTS file is found in the WINDOWS\system32\drivers\etc\ directory

Have fun

Eric

SOLVED!

Ok, the issue was just as stated.....there was a process that ran every 5 minutes to do imports.    They disabled the error notification because they go tired of seeing the...

Thanks, I am having the application folks check their code again.

But the interesting thing is that it increments by 27 every 6 minutes, even in the middle of the night...

Hey there

I do alot of work with linked servers.   There are lots of minor things that can make everything not work....so lets try to eliminate some of the easy ones...

1)...

Thanks, this solves the problem.   http://support.microsoft.com/?kbid=839279

Eric