Post reply

Maintenance plan Issue for backup sql database from one server to another server

  • July 25, 2012 at 1:41 am

    #264680

    hi......guys!!!!1

    This is a case of schedule maintanance plan

    When we create maintenance plan how to backup SQL Server database from one server to another server?

    One thing is sure we create maintanance plan and after that we can schedule backup on the same server

    But if 6 server are in network so in that case how to provide a path on network location for backup a database as i have seen there are no option for network , there is only local path present.....

    reply....thnx

  • July 25, 2012 at 1:50 am

    #1517197

    Personal preference is to always backup to local drives first then use something like robocopy to make a copy to the network share.

    I say this as if the network blips for the slighest second your backup will fail and need to be run again.

    But if you want to backup to a network drive just use a UNC path in the backup directory and ensure that the SQL Engine account write permissions to the folder.

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

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