Post reply

How to backup a SQL server 2005 database in new network location

  • June 3, 2010 at 1:21 am

    #222311

    Hai,

    How to back up a database to one network location to another location in internet.

    For example: I have testdb in my sql server. I want to testdb.bak in some other network using static ip(Internet). Exaplined in image

    waiting for reply

    thanks

  • June 3, 2010 at 6:27 am

    #1175885

    first copy the bak file on local drive then move it to desired location by "COPY" Command Prompt command

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 3, 2010 at 6:37 am

    #1175895

    I agree. Do the backup locally and then ftp the file or whatever to the remote site. If you run backup across the internet, connection interruption, etc., could cause lots of failures. Plus, it's going to be very slow and could negatively impact peformance and availability on the server.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 4, 2010 at 8:22 am

    #1176551

    Thanks for you reply. But i want to how to do this. Its possible do the backup task to remote location.

  • June 4, 2010 at 8:25 am

    #1176553

    Thnaks bhuvanesh. But i know that. I want know how to do backup task in remote location. I hope you will understand what i am saying

  • June 7, 2010 at 12:45 am

    #1176947

    guruprasadurs (6/4/2010)

    I want know how to do backup task in remote location

    exec master..xp_cmdshell ' COPY source path + file name destination path' better google for same command.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 6 posts - 1 through 5 (of 5 total)

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