How can we help you today? How can we help you today?

OLR and Extended properties

Am I right in thinking that Object Level Recovery, does not include extended properties on columns, tables etc.
kevriley
0

Comments

1 comment

Sort by
  • James B
    Looks like it - I've just tested it and it doesn't appear to script them.

    We've got an article on some of the other limitations here

    An alternative would be to restore the backup to a new DB (or use SQL Virtual Restore) then use SQL Compare and/or Data Compare to recover the objects you want.
    James B
    0

Add comment

Please sign in to leave a comment.