There have been many posts about upgrading MSDE instances to SQL and so on,
but they all seem to result in having multiple instances of the SQL server
process running. Is there a way to cleanly, organise all the databases in
such a way that there is only ONE SQL server process running that serves all
the tables required?
i.e. A default install on SBS2003 premium with LiveCommunicationsServer
would result in the following separate instances:
1. MSDE SHAREPOINT
2. MSDE SBSMONITORING
3. MSDE LIVECOMMUNICATIONS
4. SQL DEFAULT
Assuming there is no live data that needs to be backed up or moved over, how
could one merge all these into a single SQL instance, or set this up fresh
in this way?
The purpose of this is to use memory more efficiently, and make applying SQL
patches easier as there's only 1 instance, not 4.