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

Feature Request

It would be very handy if we could get the functionality to restore a database to another server from the original server. For example:

Server1 has DB 12
Restore DB 12 from Server 1 to Server 3 by selecting the backup files from the history on Server 1.

Right now we have to go to Server 3 & navigate to the backup files location & restore the files.

Does that make sense? I know if SQL backup 4 & in SQL MS this was not possible. Didn't know if it was in SQL 5 or if there was any plans for something like this.

John
laker_42
0

Comments

2 comments

Sort by
  • James Moore
    Hi John,

    The issue here is getting it to work smoothly - The backup file might not be availible from Server3's perspective - IE admin shares might be off on Server1, it might have been moved to another share which server3 cant reach etc and the SQL Backup Agent might not be running as a Domain admin or have the credentials for the local admin on Server1. Other methods of copying the file across (using SQL Server connections etc) are at best hacks and are likely to cause some degree of performance hit on the servers so I wouldn't be happy copying large files across this way.

    I agree that it would be somthing that would be a "very nice to have" feature but we havn't yet come up with a way to solve the problem more generically than assume we have admin rights etc which isnt the case for many of our customers.

    If you have any ideas on how this could be achieved then I would be interested to hear them and we will certainly keep it in mind for future releases - we are probably a little too close to release now with the initial release of Backup 5 to get it in but it would certainly be a strong contender for a future release if we could think of a good way to get it working more generically.

    Many thanks for the feedback,

    - James
    James Moore
    0
  • laker_42
    Hi James,
    Thanks for the response. For us, we have a central backup location that all servers have access to. We also standardize on all servers running under the same service account. Also, the dba would be restoring the databases & he has admin access to all the SQL servers so security should not be an issue. However, I understand we may not be the norm.
    John
    laker_42
    0

Add comment

Please sign in to leave a comment.