I have a Dumb Question

[100mbs]

We have a two Windows 2008 Servers. One running SQL Standard and the other running SQL Enterprise for SSRS.

We cant need to update the Standard version to Enterprise to enable TDE.

Can we insatll Enterprise on the server running Standard and shut down the Standard Instance and run the databases off of the new Enterprise install.

Then on the other server where Enterprise was already installed we want to install SQL standard, shutdown Enterprise and run all the Databases and SSRS from the Standard install.

Is this possible? What are the risks?

Thanks in advance i know this sounds weird and dumb but Money is a huge factor in this one.

 

[SQLSister]

No problem with upgrading the Standard to Enterpise.
But...
I'd say the biggest risk is that the server with Enterpirse may be using features only available only in Enterprise such as indexed views. It's likely they installed Enterprise on that server for a specific reason (Enterprise being much more expensive) and changing it to Standard could be disastrous.

"NOTHING is more important in a database than integrity." ESquared

 

[bborissov]

Enterprise has more features available that Standard.
So some databases created on Enterprise can't be attached to Standard edition. Like SQLSister already said - Indexed Views.
Also (on top off my head) Partitioned tables. Compressed Backups.

But you better ask here forum962.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.