RE: Upgrade of Sharepoint to SQL Server 2000 - Questions

Hi Ken,

Thanks for posting here.

For your description, I understand that you failed apply SQL 2000 SP4 to
the Sharepont WMSDE instance. If I am off base, please don't hesitate to
let me know.

By default, there are 2 MSDE instance in SBS 2k3 standard version,
MSSQL$SharePoint and MSSQL$SBSMonitoring. SharePoint (Companyweb) uses the
MSSQL$SharePoint database, while the Monitoring features use the
MSSQL$SBSMonitoring database to store data. Both of these features are
mutually exclusive for the most part. One failing does not mean the other
will have problems since each feature uses it''s own database instance.

>>- Where can the "how to" for the upgrade of Sharepoint to SQL be found?
>>(Can find no how-to doc in MS support).

If you are using SBS 2003 Premium Edition then you could upgrade the
SharePoint named instance to full SQL. The steps are listed in the
premiuminstallsteps.htm on the root of the Premium CD.

In addition, you can also find the steps on how to upgrade to SQL server in
the following KB article:
How to turn on full-text search in Windows SharePoint Services on a Windows
Small Business Server 2003-based computer
http://support.microsoft.com/default.aspx?scid=kb;en-us;837367

>>- Is the upgrade worth it?
>>(have had enough problems getting this old system stable, am still facing
>>some issues. May be best to plan this upgrade for much later, if at all).

You needn't upgrade the SharePoint named instance to full SQL, that depends
on your needs. After you upgraded the Sharepoint instance to full SQL you
enjoy Full Text Search in Sharepoint and all the advantages SQL server
provided.

WMSDE and has no storage limits unlike MSDE(Microsoft SQL Server 2000
Desktop Engine). This is fine in a small-scale environment, when you are
hosting just a few Web sites, but if your server suddenly gets popular and
you need to start hosting hundreds of sites, you may run into performance
and storage problems.

The KB article give detail information about how to upgrade to full SQL and
some troubleshooting method.
837367 How to turn on full-text search in Windows SharePoint Services on a
http://support.microsoft.com/?id=837367

More info:
The Windows SharePoint Services Administrator''s Guide and search on
"Migrating from WMSDE to SQL Server":
http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-
a6a4-3e33fa13d230&DisplayLang=en.

Hope this helps. If you have any further concern, please feel free to let
me know. I am always happy to be assistance of you.

Have a nice day!

Best Regards,

Jenny Wu
Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • RE: Upgrading to R2 premium SQL questions
    ... there are already 2 instances using MSDE ... You could upgrade the SharePoint named instance to full ... SQL from MSDE to SQL 2005. ... You cannot upgrade the Monitoring instance to SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: How to get Word using sharepoint list?
    ... Defiantly do not want Word access SQL directly even that I have the full ... see all live data from the Sharepoint list. ... do you have access to the Sharepoint SQL Server database at all (I mean, ... connection - in Word the simplest approach is probably to use a .odc file to ...
    (microsoft.public.word.mailmerge.fields)
  • RE: upgrade sharepoint database to SQLserver - connect error
    ... 2005 database after he move the sharepoint data from MSDE to SQL 2005. ... This newsgroup is primarily for issues involving deployment, configuration, ... | I am trying to move my SharePoint data bases from MSDE to the Sql Server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Configuring Full Text Search FOr SharePoint Web
    ... My SharePoint database had been upgraded to SQL and the data was being ... You need to make sure that you have upgrade your sharepoint instance to ...
    (microsoft.public.windows.server.sbs)
  • RE: Upgrade of Sharepoint to SQL Server 2000 - Questions
    ... since it is not yet at full SQL. ... will put the upgrade to full SQL WMSDE onto my "maybe" ... > SharePoint named instance to full SQL. ... > enjoy Full Text Search in Sharepoint and all the advantages SQL server ...
    (microsoft.public.windows.server.sbs)
Loading