What are the challenges you face when working across database platforms? Take the survey

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.


  • Options
    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

Sign In or Register to comment.