Post reply

Creating Backup Job in SQL Server 2005 across network

  • October 21, 2009 at 4:50 am

    #212236

    Can anyboby tell the prodedure how to make a backup file for the selected database to save on to the different system. (i.e. the destination system will be in network)

  • October 21, 2009 at 6:26 am

    #1068798

    Just so you know, this can frequently result in slower backups that cause some visible load on the server. I prefer to backup locally and then move the file across the network.

    But... You just need to refer to the correct location by server and share name. Make sure the service that SQL Server runs under has access to it. The backup script would look something like this:

    BACKUP DATABASE X

    TO DISK = '\\myserver\myshare\x.bak'

    "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

Viewing 2 posts - 1 through 2 (of 2 total)

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