Robocopy & long file names

[cheryl]

We're trying to use Robocopy to copy some SQL files. The path is :

 

f:\microsoft sql server\mssql$sims\mssql.1

 

I cannot get robocopy to recognise 'microsoft sql server' . I've tried making it the short version micros~1 , also put quotes round it and also round the whole path, but it still won't recognise it.

 

The data is in F:\mssql$sims\mssql.1 on some servers and they copy fine, so it's definitely the bit with spaces in that's causing the problem.

[tech_guy]

This is what we do with speech marks and robocopy and it works fine:

 

"C:\Program Files\Microsoft SQL Server\Backup \\fs2\c$\temp" * /S /E

Edited January 18, 2008 by tech_guy

[ajbritton]

I think that tech_guy meant to say

 

"C:\Program Files\Microsoft SQL Server\Backup" \\fs2\c$\temp * /S /E

 

When you need to specify a file path that includes a space on a command line, the individual parameter should be enclosed in double quotes.