Post reply

do backup jobs also backup partitions on a table?

  • December 2, 2011 at 3:12 pm

    #247200

    Is there a different syntax to backup partitions or we can use the same syntax like we backup any other database.

  • December 2, 2011 at 3:45 pm

    #1416211

    same syntax. Partitioned tables are still held within the same database. You may want to look at filegroup backups if the databse is very large, but it all comes under the same backup command and the fact you have partitions makes no difference.

    ---------------------------------------------------------------------

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

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