|
Home > Archive > MS SQL Server > January 2006 > Upgrade/Downgrade from SQLEXPRESS to SQL 2000 for Windows Sharepoint Services!?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Upgrade/Downgrade from SQLEXPRESS to SQL 2000 for Windows Sharepoint Services!?
|
|
| Jörg Schreiber 2006-01-14, 8:23 pm |
| I was told that it might be better to post here - so sorry in advance for
cross posting that...
Hello,
due to technical probs with our VPS-System i had to try an installation of
SQLEXPRESS and i finally made our Windows Sharepoint Services (on
VPS/Plesk/Virtuozzo Win2k3 Server standard) work.
Now i want to use SQL Server 2000 in order to activate the full-text search
and indexing of the Sharepoint site.
How can i migrate from SQLEXPRESS to SQL Server 2000 ?
Or is there a way to full-text search the sharepoint document libraries
saved in the SQLEXPRESS database?
regards
Jörg Schreiber
| |
| Jörg Schreiber 2006-01-14, 8:23 pm |
| Addition:
What happens if i simply run SQL Server 2000 setup.exe on this Server? Are
the existing instances of SQLEXPRESS recognized and updated?
| |
| Paul S Randal [MS] 2006-01-16, 3:23 am |
| By moving to SQL Express, you've upgraded your databases to the SQL Server
2005 format. This is a one-way operation and so these databases cannot be
attached to any version prior to SQL Server 2005. Full-text search is not
part of SQL Express in RTM but may be included in a future release. Your
best bet at this stage is to either recreate the SQL2000 databases or to
purchase an edition of SQL Server 2005 that includes full-text search.
Regards
--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jörg Schreiber" <joerg_schreiber@gmx.net> wrote in message
news:dqbm5e$2bd$1@ne
ws1.nefonline.de...
>I was told that it might be better to post here - so sorry in advance for
>cross posting that...
>
> Hello,
>
> due to technical probs with our VPS-System i had to try an installation of
> SQLEXPRESS and i finally made our Windows Sharepoint Services (on
> VPS/Plesk/Virtuozzo Win2k3 Server standard) work.
> Now i want to use SQL Server 2000 in order to activate the full-text
> search
> and indexing of the Sharepoint site.
> How can i migrate from SQLEXPRESS to SQL Server 2000 ?
> Or is there a way to full-text search the sharepoint document libraries
> saved in the SQLEXPRESS database?
>
> regards
> Jörg Schreiber
>
>
|
|
|
|
|