SQL Snapshots

Just been using SQL snapshots to compare a schema after an update has been applied.

Noticed that there were still differences between the snapshot and the original DB just after the snapshot – it appears that Full text catalogs are not supported as part of a snapshot.

Something to remember.

http://technet.microsoft.com/en-us/library/ms175158.aspx#LimitsOnDbSS

 

Also if you try to restore then you need to be aware that the full text catalogs are deleted and you cannot create any new ones after the restore until you take it offline and then online again.

http://connect.microsoft.com/SQLServer/feedback/details/773710/unable-to-perform-full-text-ddl-after-reverting-from-db-snapshot

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s