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]

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>