RE: MSDE to SQL Server
- From: v-yanniw@xxxxxxxxxxxxxxxxxxxx ("Jenny wu [MSFT]")
- Date: Wed, 21 Sep 2005 05:45:51 GMT
Hi Kelvin,
Thanks for posting here!
For your description, I understand that you want to upgrade MSDE instances
to full SQL instances. If I am off base, please don't hesitate to let me
know.
We can upgrade the instance SHAREPOINT to SQL and it is not recommended
that upgrade SBSMONITORING to SQL for the code for the SBS monitoring is
all for pulling the information from the MSDE instance. Additionally, it is
not supported to upgrade the instance of MSDE installed for Monitoring
(SBSMONITORING) and it is really not needed to upgrade SBSMONITORING.
You can follow the instructions are outlined in Premiuminstallsteps.htm on
the root of the Premium CD to upgrade the instance SHAREPOINT to SQL and it
is no need to manually migrate data from MSDE to SQL server and all dada is
kept.
Before you do the upgrade process, I suggest you backup your Companyweb
data firstly in case any unexpected things happen. You can refer to the
following KB article to backup:
829112 How to back up and restore http://companyweb data in Windows Small
Business Server 2003
http://support.microsoft.com/?id=829112
To upgrade the instance of Microsoft SQL Server Desktop Engine (Windows)
(WMSDE) that is used for Windows SharePoint Services, follow these steps:
1. Insert the Microsoft Windows Small Business Server 2003 Premium
Technologies installation CD-ROM in your computer's CD-ROM or DVD-ROM
drive. The Autostart option may start the Microsoft Windows Small Business
Server 2003 Premium Technologies Setup wizard. If the wizard does not
start, click Start, click Run, locate the CD-ROM or DVD-ROM drive, and then
click Setup.exe.
2. On the first page of the Microsoft Windows Small Business Server 2003
Premium Technologies Setup wizard, click Install Microsoft SQL Server 2000.
*Note: If Windows Small Business Server 2003 came preinstalled on your
server, your original equipment manufacturer (OEM) may have created a
shortcut on the desktop that installs the Premium Technologies.
3. When you receive the SQL Server 2000 SP2 and below message, click
Continue. You will install SQL Server 2000 Service Pack 3a later.
4. On the Welcome page, click Next.
5. On the Computer Name page, click Local Computer, and then click Next.
6. On the Installation Selection page, click Upgrade, remove, or add
components to an existing instance of SQL Server, and then click Next.
7. If this is the first instance of SQL Server 2000 to be installed on
Windows Small Business Server 2003, the CD-Key page will open. On the
CD-Key page, type your Windows Small Business Server 2003 product key in
the space that is provided, and then click Next. The product key is found
on the back of the Windows Small Business Server 2003 CD-ROM case.
*Note: If Windows Small Business Server 2003 came preinstalled on your
server, the product key is located on the Certificate of Authenticity
(COA). The COA is a multicolored label that is located on the side or the
top of your computer.
8. On the Instance Name page, click to clear the Default check box. In the
Instance name list, click SHAREPOINT, and then click Next.
*Important: Do not upgrade the instance of WMSDE installed for Monitoring
(SBSMONITORING). Windows Small Business Server 2003 does not support this
instance.
9. On the Existing Installation page, click Upgrade your existing
installation, and then click Next.
10. On the Upgrade page, click to select the Yes, upgrade my programs check
box, and then click Next.
11. When you receive the Do you want to install additional components
message, click Yes.
12. If this is the first instance of SQL Server 2000 to be installed on
Windows Small Business Server 2003, in the Components list, click to select
the Management Tools check box and the Books Online check box.
13. On the Select Components page, under Subcomponents, click to select the
Full-Text Search check box, and then click Next.
14. On the Start Copying Files page, click Next.
15. On the Setup Complete page, click Finish.
After you upgrade successfully, check the instance version. If it is not
SP4, you need apply SP4 to the instance using SBS 2003 SP1 CD.
For detail information, please refer to 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
Hope above information helps! If you have any further concern or question
on the issue please feel free to let me know. I am looking forward to your
reply!
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.
--------------------
>Thread-Topic: MSDE to SQL Server
>thread-index: AcW9+N/9WlWCJItJRYWWXNq/GTF85g==
>X-WBNR-Posting-Host: 219.77.72.53
>From: "=?Utf-8?B?S2VsdmluIE11aQ==?=" <KelvinMui@xxxxxxxxxxxxxxxxxxxxxxxxx>
>Subject: MSDE to SQL Server
>Date: Tue, 20 Sep 2005 08:35:05 -0700
>Lines: 10
>Message-ID: <B1BF3B0C-4D2C-43B0-B668-09654C845C17@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:154853
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>I am using SBS 2003 Standard, and purchase the Upgrade to Premium Edition.
I
>haven't follow the instruction fou upgrade the MSDE to SQL Server during
>installation. Right now, the SQL host my ERP application database, and I
>located the SharePoint and SBS Monitoring MSDE is running. I would like
to
>upgrade those instance into SQL Server, ans migrate the data in MSDE as
well.
> I notice there are 1 SQL and 2 MSDE instance running and it used lots of
the
>system resources. The SBS 2003 has applied SP1 and SQL has applied SP4/
>Could you suggest solution and thanks in advance
>--
>Kelvin Mui
>
.
- Prev by Date: RE: Help with Resolution for MS 827929 (Server Error in '/' Applicatio
- Next by Date: RE: Setting up a new web site on IIS for internal use only
- Previous by thread: RE: Help with Resolution for MS 827929 (Server Error in '/' Applicatio
- Next by thread: RE: Setting up a new web site on IIS for internal use only
- Index(es):
Relevant Pages
|
