Red Gate forums :: View topic - Error message attempting to do restore after upgrading 6.4
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Error message attempting to do restore after upgrading 6.4

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CVR



Joined: 17 May 2012
Posts: 2

PostPosted: Thu May 17, 2012 11:55 am    Post subject: Error message attempting to do restore after upgrading 6.4 Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Fri May 18, 2012 1:37 am    Post subject: Reply with quote

Could you please post the restore command you are running, and also the result of running RESTORE FILELISTONLY on the backup file?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
CVR



Joined: 17 May 2012
Posts: 2

PostPosted: Fri May 18, 2012 11:49 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Fri May 18, 2012 3:20 pm    Post subject: Reply with quote

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.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group