Home Forums SQL Server 7,2000 Backups Backup Database on remote server RE: Backup Database on remote server

  • October 7, 2008 at 7:37 am

    #881638

    Wildcat (10/6/2008)

    1. Make the remote folder shared, and make sure the SQL Server Agent has write-permission on that folder. (Maint plan can't see the remote shared folder. You have to input the address.)

    2. Use backup command:

    BACKUP DATABASE dbname

    TO DISK = 'remote folder address'

    give you any sample for 'remote folder address' ?

    thanks