Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-08-2010, 08:33 AM   #1
madEG
Newly Registered User
 
Join Date: Jan 2007
Location: Washington D.C.
Posts: 309
Thanks: 33
Thanked 0 Times in 0 Posts
madEG is on a distinguished road
SQL Server Express '05 on top of SQL Server '08 running as mirror?

Hello,

Today is supposed to be my day off!

I get a call this AM from my network admin who is asking if he can install SQL Server express 2005 as an additional instance of sql server on a server that already has sql server 2008 in place and acting as a mirror for a principal/mirror pair for my sharepoint farm.

Has anyone added a sql server express 2005 instance over/in addition to an already in place sql server 2008 (standard edition I think) instance?

Why? For his vCenter virtual machine stuff -- sql server express 2005 is included in the install, and would do all the config stuff auto-magically - which is his draw...

I did some looking around and i think the answer is just make sure the db engine is the only thing installed, and not the share components, or management studio stuff, etc, since it would be downgrading the version and 2008 should be backwards compatible anyway, no?

Thoughts?

Thanks!

-Matt G.

madEG is offline   Reply With Quote
Old 11-16-2010, 06:25 AM   #2
SQL_Hell
SQL Server DBA
 
SQL_Hell's Avatar
 
Join Date: Dec 2003
Location: UK
Posts: 1,325
Thanks: 15
Thanked 39 Times in 37 Posts
SQL_Hell will become famous soon enough
Re: SQL Server Express '05 on top of SQL Server '08 running as mirror?

You can do this

But personally I would put the database on the 2008 instance and set the database to run in 2005 compatability mode, which is 90
SQL_Hell is offline   Reply With Quote
Old 11-18-2010, 02:59 PM   #3
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 665
Thanks: 9
Thanked 53 Times in 51 Posts
kevlray will become famous soon enough
Re: SQL Server Express '05 on top of SQL Server '08 running as mirror?

If I remember correctly, as long as you install older versions first, then SQL works pretty good. Also ask the people at SQLServerCentral.com. They have the largest collection of SQL experts that I have seen.

kevlray is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating New MDB, easily upsizeable to SQL Server Pleasure Theory and practice of database design 16 09-15-2008 12:11 PM
sql server 2005 express Darth Vodka SQL Server 2 04-09-2008 01:29 AM
access to sql server express connection grahamsyuk SQL Server 5 10-03-2007 06:56 PM
Upgrading from Access 2000 to SQL Server 2005 Express swade30 SQL Server 3 10-04-2006 01:00 PM
SQL Query: Having 'OR' clause causes problems rusco Queries 3 11-20-2004 09:26 PM




All times are GMT -8. The time now is 05:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World