Post reply

Can I Restore with Device to Database on another Server?

  • February 21, 2018 at 1:26 pm

    #329427

    my client wants me to set up an incremental database backup, which entails restoring to a device, not a file
    I need to transfer that to a development machine
    I have transferred backup via .BAK files for a decade now but how do I handle a device backup?

    thanks

    newbie DBA but not by choice

  • February 21, 2018 at 1:49 pm

    #1980678

    Is it a tape backup device or something else?

  • February 21, 2018 at 1:53 pm

    #1980682

    It is possible if the device is (or can be made) available on the other server. From there you can do a normal restore action.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • February 21, 2018 at 2:14 pm

    #1980687

    I created a logical device on the database server

  • February 21, 2018 at 2:25 pm

    #1980689

    Seggerman-675349 - Wednesday, February 21, 2018 2:14 PM

    I created a logical device on the database server

    You need to create a logical device on the destination server pointing to the same location as the device on the originating server. 
    The paragraph "Use a logical device" on this URL can help you understand it.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • February 21, 2018 at 2:47 pm

    #1980696

    Seggerman-675349 - Wednesday, February 21, 2018 2:14 PM

    I created a logical device on the database server

    How to do it depends on if it's a tape or file - that's why Evgeny asked which one.
    Devices just point to the backup on tape or the name of the backup on the file system. If it's pointing to a file, you can copy or move that as you would any other file.

    Sue

  • February 22, 2018 at 6:06 am

    #1980754

    It's all on disks - I'll try and see what the name of the file created with a device backup is
    sadly, the server can access the  development machine - but not vice versa -

  • February 28, 2018 at 6:20 am

    #1981440

    Seggerman-675349 - Wednesday, February 21, 2018 1:26 PM

    my client wants me to set up an incremental database backup, which entails restoring to a device, not a file
    I need to transfer that to a development machine
    I have transferred backup via .BAK files for a decade now but how do I handle a device backup?

    thanks

    newbie DBA but not by choice

    a sql server backup device?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply