How to move a SQL Server Database from Enterprise to Standard Edition - TFS & Visual Studio ALM - by Neno Loje

TFS & Visual Studio ALM - by Neno Loje

(formerly Team System, VSTS)

News

Recent Posts

Community

Tags

Email Notifications

VSTS Blogs

VSTS Community

My Other Blogs

German VSTS Websites

Archives

How to move a SQL Server Database from Enterprise to Standard Edition

Cross-posted from my other blog:

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]