When I try to copy a database from one server to the same server (2008 R2) by using the wizard, I lose all extended properties on the schemas defined for the database.
The extended properties for other objects (tables, columns, indexes) are kept.
Has anyone experienced this before? Is this expected behaviour? What can be done about this?
Please see: http://msdn.microsoft.com/en-gb/library/ms188451(v=sql.90).aspx
Database extended properties
The SMO method will transfer database object extended properties but not extended properties for the database itself. The detach-and-attach method will copy all extended properties.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?