How to move a SQL Server Database from Enterprise to Standard Edition
Cross-posted from my other blog:
![Microsoft_SQL_Server_Logo_thumb[1]](http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/vstsblog.metablogapi/6013.Microsoft_5F00_SQL_5F00_Server_5F00_Logo_5F00_thumb1_5F00_thumb_5F00_260A3614.png "Microsoft_SQL_Server_Logo_thumb[1]")
The Problem
- You have a database (e.g. TFS collection database) in SQL Server Enterprise Edition.
- You want to backup and restore this database on a SQL Server Standard Edition.
- You get an error message on restore that some features are not supported.
The Solution
…
[Read the full post]