Error message attempting to do restore after upgrading 6.4

CVR

Hi,

I am getting the error message:

"One or more database file names contain invalid characters, such as \ / : * ? " < > |"

when trying to perform a restore from a backup file.

The backup file name has not changed since upgrading from 6.4 to 7.0 (yesterday).

I have done a quick search on Google and found the same error message could come up on v5.0 and the fix was to amend the SQL Server path in the registry.

Can anybody confirm if this is still the way to fix this problem; I'm not exactly happy about that if it is!

Many thanks,

Richard

petey

Could you please post the restore command you are running, and also the result of running RESTORE FILELISTONLY on the backup file?

CVR

Petey,

Thanks for the response.

Not sure I can give you the info you have asked for though: the problem occurs when using the restore wizard within SQL Backup.

Steps are:

1. Select "Browse for Backup Files to restore" in the dropdown
2. Select the server to restore to in the dropdown
3. Click the Add Files button and choose the backup file to restore
4. Click Next to take me to Page 2 of the wizard
5. Use the Overwrite existing database option and select the target database

Immediately upon doing this last step, I get the error message as described before appearing below the database selection dropdown, with a red "no entry" symbol next to it.

Thanks,

Richard

petey

Could you please use SQL Profiler to trace the commands used by the SQL Backup GUI? The last command is probably the one raising the error. You could try running the same command, if possible, in Management Studio to check if the same error is raised.

Thanks.