What are the challenges you face when working across database platforms? Take the survey
Options

Trial Version 7:Attaching to other servers to do restores...

SQL_ME_RICHSQL_ME_RICH Posts: 112
edited July 5, 2012 7:14PM in SQL Backup Previous Versions
Is the trail version of SQL Backup 7 able to connect to other servers when browsing the file system for backup files? I have large backup files (even with compression) on other servers that I need to use to restore those databases on yet another server.

Every time I try to attach to a server, it lets me, but when I navigate to the area I need to use a backup file from, I get errors making it seem like the file is not there.

Any thoughts would be most appreciated.

Comments

  • Options
    Due to the way SQL Backup handles credentials for viewing files on other servers, there are a few known issues where remote browsing doesn't work properly. Without knowing more about your specific issue, it's hard to say exactly what it is, but it's probably one of the two following issues:

    http://www.red-gate.com/supportcenter/c ... 0903000369

    http://www.red-gate.com/supportcenter/C ... 000417.htm

    Let me know if either of those articles helps at all!
    Andy Campbell Smith

    Red Gate Technical Support Engineer
  • Options
    Andy - thank you for getting back to me on this. I have looked at the links you provided, but I probably need to be more specific here. It's not that in the process of doing a restore that I cannot add files from another server's share, but once I do - I get the Red X and type Unknown, and file name leading with 'Unavailable' in Red text.

    Here is a snapshot for you...
    RedGate1.jpg


    I am hoping that my windows login will suffice to resolve this, because I do not have a lot of flexibility here. It's the same login for all the various boxes with the same credentials on each, but as you can see - no joy in getting to the files.

    Any help would be appreciated.
  • Options
    Hmm. I'd guess this was a permissions problem - the account that's running the SQL Backup Agent service on the server you're trying to run the restore on needs to have read permissions on the folder containing the backup file.

    Can you confirm that the account running the SQL Backup Agent service has the appropriate permissions? You can check the account running it with the Services utility in Windows - it ought to show up as "SQL Backup Agent-<instancename>". If you right-click it and select 'Properties', you can change the account it logs on as.
    Andy Campbell Smith

    Red Gate Technical Support Engineer
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    I had the same problem!

    Took a hammer to it and added the Service Account to the Local Admin Group and rebooted the server!

    Works now 8)
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
Sign In or Register to comment.