Copy database from SQL Server 2005 Enterprise Edition to Standard Edition

Peter_Cull
Peter_Cull used Ask the Experts™
on
Is it possible to copy a database from SQL server 2005 Enterprise Edition Eval to SQL Server 2005 Standard Edition using Backup Database and Restore Database commands?  Both servers run on Windows server 2003 std edition 32 bit machines.  We're not using any advanced features found only in EE.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
>Is it possible to copy a database from SQL server 2005 Enterprise Edition Eval to SQL Server 2005 Standard Edition using Backup Database and Restore Database commands?
yes, the edition does not matter.

Author

Commented:
Thanks Angellll

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial