OLR and Extended properties

kevrileykevriley Preston, UK Posts: 121 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

Comments

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