Post reply

Location of Backup file

  • June 23, 2011 at 7:30 am

    #242580

    We have two servers in a network. I want to backup a database on server A and restore to server.

    Is it better to take the backup on Server A or on Server B?

  • June 23, 2011 at 7:34 am

    #1343025

    Can you be a little more specific?

    Are you saying you have an instance on each server and you're trying to backup a database on server A?

    It doesn't matter from which server you initiate the action.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • June 23, 2011 at 11:48 am

    #1343279

    It's going to depend on the network and how much space is available. If your network is solid and there's enough space on both server A and server B to store both the backup and the restored DB then it doesn't much matter. If one drive is short on space back up to the other and restore from there. And if your network sees packet drops that may interfere with the backup then do the backup to server A, copy it to server B outside of SQL, and then restore from B.

  • June 24, 2011 at 9:23 am

    #1343745

    There are 2 servers with 1 instances each.

    The network has limited band width but do not drop.

    So is it preferable to have the backup in server A and restore Server B from shared location in A or vice versa.

    Both the server has enough space for taking backup.

  • June 24, 2011 at 10:23 am

    #1343792

    It won't make much of a difference which server you back up to and restore from.

  • June 25, 2011 at 1:16 am

    #1344039

    Thanks everybody for all your inputs.

  • June 28, 2011 at 6:40 am

    #1345130

    I would say backup up to the server you want to restore. This will restore a bit faster. But as said earlier this will can be done either way.

    Thank you.
    Aatish Patel

  • June 28, 2011 at 1:19 pm

    #1345445

    Backups create the backup file on the local disk of the server on which the backup is being performed. You would need to transfer to bak file over the n/w then restore on destination

    Jayanth Kurup[/url]

  • June 28, 2011 at 1:29 pm

    #1345451

    It is possible to back up over the network. I know I've ran into issues doing it but I don't remember what they were and we have a lot of servers doing it now so I know it's possible.

  • June 28, 2011 at 1:52 pm

    #1345474

    Remote backups require configuration changes such as setting Trace flag 1807 , having accounts with the right privileges , solid network , etc.

    A simpler approach would be to take the backup on the local and transfer it over the network after compression if required.

    I would not recommend remote backups , if it was required probably a tool would be better.

    Jayanth Kurup[/url]

  • July 1, 2011 at 9:33 am

    #1347111

    Thanks for your inputs.

Viewing 11 posts - 1 through 10 (of 10 total)

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