Post reply

Partial backup and FILELISTONLY

  • July 18, 2011 at 2:45 pm

    #240952

    After backing up few read-only filegroups by:

    backup database <db>

    filegroup='<fg1>',

    filegroup='<fg2>'

    to disk='<path>'

    restore filelistonly is giving me a list of every single filegroup in the db, not just those two.

    Am I missing something?

    Any thoughts?

  • July 26, 2011 at 6:12 am

    #1358422

    All the files are listed but there is a column "IsPresent" to indicate whether a particular file is actually included in the backup set.

    I think it needs all the files in order to set up the initial database restore properly, even if you haven't actually restored all of the files/filegroups yet.

  • July 26, 2011 at 7:47 am

    #1358516

    Thanks, I completely missed it...

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

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