Post reply

Backup

  • June 30, 2008 at 5:19 am

    #193270

    Hi Experts,

    Is it possible to take backup to a remote machine in which i have full permissions.I need to take full backup of a database to another machine in same network.

    TIA

  • June 30, 2008 at 6:49 am

    #836066

    yes u can take backup to remote machine by sharing the path in network through TSQL we can take backup.Try it i am doing that only.

    you can specify path like "\\testsvr\backup"

    its stores backup folder.

  • July 1, 2008 at 2:01 am

    #836484

    [font="Verdana"]Hi Rathesh,

    If the database size is small then you can take the backup directly to share drive else you can take the backup to the local disk and then copy from there to shared drive, coz time taken to backup the db will depends on network speed![/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • July 1, 2008 at 2:53 am

    #836513

    As Anjan mentioned you can use a network share, but make sure that SQL Server's service account has permissions to write to the network share.

    You can read more on the requirements for this in Books Online:

    http://msdn.microsoft.com/en-us/library/ms179313.aspx Read the section "Backing Up to a File on a Network Share"

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • July 1, 2008 at 3:44 pm

    #836933

    bear in mind that if you backup accross the network, there is a risk that the backup could be corrupted if there is a network glitch - so it may be better to backup to a local drive first and then copy it to the other network drive. That way, you can retain the local backup until it has been copied safely to the other location at which point you can delete the original - so you are covered

    just my 2c 🙂

  • July 1, 2008 at 3:55 pm

    #836937

    Usually you'll find if there's a network glitch, the backup will fail. I almost never run the backup across the network. run it locally and copy it.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • July 1, 2008 at 3:58 pm

    #836940

    Hi Steve - that's what I was trying to say :w00t:

  • July 2, 2008 at 1:21 am

    #837020

    Thanks all

    The problem is that there is not enough space in local disk and am trying to take back from a client machine to another remote machine..

    But its throwing error 🙁

  • July 2, 2008 at 4:50 am

    #837091

    How about

    1. Using third party backup tool which creates compressed backup file.

    2. Writing a stored procedure to take backup which will retry if the backup fails.

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

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