Post reply

Automatic back up

  • May 18, 2005 at 12:42 pm

    #110445

    Greetings,

      I am new to SQL and have no choice but to learn, any way I need to setup a daily back up system that took all DB back ups to an FTP server, can any one help me out here ?

     

     

  • May 18, 2005 at 1:55 pm

    #559702

    I don't have any experience with ftp, but I would think that you would create a maintenance plan to back your database up to a local disk (which includes scheduling), and then outside of SQL set a schedule to send it the ftp server.

    Alternatively, you could manually create a job in SQL Server Agent to backup the database, and then in a separate step within the job, kick off your ftp process.

    Steve

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

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