Options

OLR and Extended properties

kevrileykevriley Posts: 129 Gold 1
edited October 20, 2011 12:14PM in SQL Backup Previous Versions
Am I right in thinking that Object Level Recovery, does not include extended properties on columns, tables etc.
Kevan Riley
Riley Waterhouse Limited
Twitter: @kevriley
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.