I am working with Automation team and for the sake of testing i have created the snapshot, the database contains FULL TEXT Catalogs...
so, when i have restored the Snapshots to database i have lost all FULL TEXT catalogs..
FYI.. must backup of Full text CATALOGS before taking any snapshot backups or restores
fyi...https://technet.microsoft.com/en-us/library/ms179557(v=sql.105).aspx
Advantages of using snapshots:
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/
so, when i have restored the Snapshots to database i have lost all FULL TEXT catalogs..
FYI.. must backup of Full text CATALOGS before taking any snapshot backups or restores
fyi...https://technet.microsoft.com/en-us/library/ms179557(v=sql.105).aspx
Advantages of using snapshots:
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/
No comments:
Post a Comment