Post reply

Is there a way to do copy-only backups from a SSIS package?

  • July 10, 2012 at 1:10 pm

    #147361

    I have a process that I am converting to an SSIS package and any help would be greatly appreciated.

    The process involves backing up a database and restoring it to another server for reporting, there are several other steps along the way but these are the main tasks.

    I am currently using the Back Up Database Task (Under Maintenance Plan Tasks) to take the backup and am wondering whether there is a way to do a Copy-Only backup. I see there is a way to view the T-SQL but I don't see a way of adding in the WITH COPY_ONLY.

    Any ideas? Is this possible?

    Thanks

  • July 10, 2012 at 1:14 pm

    #1511153

    You will probably need to use a SQL Task and write the backup process using T-SQL.

  • July 10, 2012 at 1:15 pm

    #1511156

    Lynn Pettis (7/10/2012)

    You will probably need to use a SQL Task and write the backup process using T-SQL.

    Only trouble is will the SQL Task wait for the backup to complete before trying to continue on with the package?

  • July 10, 2012 at 1:16 pm

    #1511157

    Yes.

  • July 10, 2012 at 1:22 pm

    #1511159

    Lynn Pettis (7/10/2012)

    Yes.

    Awesome, thanks for your help! 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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