Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have a Dumb Question

Status
Not open for further replies.

100mbs

MIS
Feb 14, 2002
142
US
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top