How can we help you today? How can we help you today?

unable to restore using GUI

After a fatal data error overnight I tried to restore from my 6:30am Transaction Log file this morning. When I right clicked on it and selected restore it came back with an error: Selected backup cannot be restored. SQL Backup has detected that more recent backups have used the same backup file name. My backups are saved in the format of dbname_Date_HHMMSS. No backup has the same name. when I click the restore the button and try and select the files they aren't even listed. I finally was able to restore by adding the files and going through but I don't understand why SQL Backup is saying that files have the same name.
Giggles220
0

Comments

6 comments

Sort by
  • Matthew Flatt
    Hi,

    This behaviour sounds extremely strange and I haven't encountered it before.

    Was it just the one file that came up with this error or is it a regular occurrence?

    Thanks
    Matthew Flatt
    0
  • Giggles220
    I had this happen for several files. Now I can't seem to reproduce it at all now.
    Giggles220
    0
  • Andrew Hodge
    I have had this happen yesterday for all the full database backups on one of our servers. The odd thing is this only affects a remote GUI. It does not affect the GUI if I run it locally on the server however?

    Error
    'SQL Backup has detected that more recent backups have used the same backup file name(s)'

    All our backups use the <AUTO> tag so include the date and time so the files do not have the same name?

    I have some screenshots of the error and lack there of if you are interested.
    Andrew Hodge
    0
  • Andrew Hodge
    I have managed to resolve this using the same workaround as the issue with verify (stickied in the forum). But for completeness

    I deleted the local data cache located in the folder
    C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data. This will cause the user interface to fetch the backup history data in order to create a new local cache which could have a temporary performance impact on the GUI.
    Andrew Hodge
    0
  • Matthew Flatt
    Andrew,

    If you could e-mail your screenshots etc to support@red-gate.com quoting reference F0014822 that would be useful.

    Thanks!
    Matthew Flatt
    0
  • Matthew Flatt
    Giggles220,

    Have you deleted the client side cache in C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data or is it still on your system?

    If you have not deleted it would you be able to send it to support@red-gate.com quoting the reference above?

    Andrew,

    If you run into this again could you also do the same?

    Thanks guys!
    Matthew Flatt
    0

Add comment

Please sign in to leave a comment.