Actually just found this link - http://technet.microsoft.com/en-us/magazine/cc160891.aspx - when looking for Robocopy help. Might be interesting.

Else, http://www.mydigitallife.info/2007/05/07/robocopy-syntax-command-line-switches-and-examples/ is a link with a good bit of information.

If you search...

Yes, verify that they are specifying port number but do you have named pipes enabled on the server? Configuration Tools > SQL Server Configuration Manager > SQL Server Network Configuration

That...

Just to reiterate the original posters comments, he is aware of how to get past the issue but he does need to know what it is happening on the one...

I have used gzip in the past as it is a bit more robust if you want to script it out. The only oddity with using it is when you...

Check your ansi_padding settings.

Grab a hacky sack and a couple co-workers and have fun. I have found the results to be amazing!

I am a bit picky so, I would possibly do this a bit different in that I would restore the new database as a different name than the original until...

Its a limitation built in to linked server functionality.

That is a fairly deep question, even though it doesn't seem that way. The answer is Yes, but it has to be qualified with "it depends" and it really does...

Is the date range in your query causing you to go against multiple partitions or just one? I would be curious to know if you are seeing parallelism in the...

John,

You had explained yourself fine the first time. 😉 I'm not always so quick though...

What you are saying makes sense theoretically.

I did find this in relation to...

I can't say for sure about the SQL 7 tools but I know that you can run the 2000 tools alongside the 2005 tools and the 2008 tools. So, my...

The information there is truly volatile. What do you mean by there is no activity during that 5 minutes? It could be that other activity is causing that information to...

"The effective permissions on an object granted to a member of more than one role are the cumulative permissions of the roles, although a denied permissions in one role has...

Does this post sound like your situation? http://www.sqlservercentral.com/Forums/Topic379152-357-1.aspx