Re: SQL service pack 4 & SBS 2003 premimum version
- From: v-natliu@xxxxxxxxxxxxxxxxxxxx (Nathan Liu [MSFT])
- Date: Mon, 23 May 2005 12:50:49 GMT
Hello Don,
Thank you for posting in the SBS newsgroup.
Also, many thanks for Dean's great input.
According to your description, I understand that you have some questions
about the installation of SQL SP4 in SBS 2003 Premium. If I have
misunderstood your concern, please don't hesitate to let me know.
First of all, please refer to the following information:
SBS SharePoint with SQL
SBS Intranet setup always installs SharePoint with MSDE regardless of
whether SQL server is being installed or not.
If SharePoint Setup detects another instance of SQL 7.0/2000 or MSDE
7.0/2000 during the setup, it will install the sixteenth instance of MSDE
alongside the initial instance. In these cases, SBS setup behaves no
differently than the clean install.
To install SBS SP1
By default, SQL Server 2000 Desktop Engine (MSDE) 2000 Service Pack 4 is
automatically applied to the instances of SQL Server 2000 MSDE that were
installed during Windows Small Business Server 2003 Setup, including the
Monitoring (SBSMONITORING) MSDE instance and the SharePoint Services
(SHAREPOINT) WMSDE instance.
Additionally, if you have Windows Small Business Server 2003 Premium
Edition, and you have installed ISA 2004, MSDE Service Pack 4 is
automatically applied to the ISA Server 2004 Firewall (MSFW) MSDE instance.
You will also need to install SQL Server Service Pack 4 if you are running
instances of SQL Server 2000.
Backup SQL database
SQL Server data can be backed up in simple recovery mode using the Volume
Shadow Copy service.
In reference to your previous question, the other instances of SQL Server
2000 need to be manually applied to SQL Server 2000 SP4. You can use
Enterprise Manager to create a database backup.
I hope this helps. If you have any questions or concerns, please do not
hesitate to let me know. I am always happy to be of further assistance.
Best regards,
Nathan Liu (MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: <dbj>
>References: <uNORvTpXFHA.3140@xxxxxxxxxxxxxxxxxxxx>
<ese1TipXFHA.2684@xxxxxxxxxxxxxxxxxxxx>
>Subject: Re: SQL service pack 4 & SBS 2003 premimum version
>Date: Sun, 22 May 2005 13:33:44 -0500
>Lines: 43
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>X-RFC2646: Format=Flowed; Response
>Message-ID: <O#sYLzvXFHA.1384@xxxxxxxxxxxxxxxxxxxx>
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: cpe-66-61-23-125.midsouth.res.rr.com 66.61.23.125
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:120579
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Hi Dean,
>
>Thanks for the feedback. We are running SharePoint using the full version
>of SQL (not MSDE). Are you saying there are issues if that is the case?
>ISA is not installed on this SBS server.
>
>Also, I do have a LOB app, do you think there could easily be issues if
they
>have not "blessed SP4" yet? I am concerned with security issues if the
>latest patches are not applied. Since each database instance are upgraded
>manually, can I simply make a database backup (using MS Enterprise Mgr) of
>my LOB database instance and restore if there are issues? Thanks.
>
>Don
>
>
>"Dean Calvert [SBS-MVP]" <dean@xxxxxxxxxxxxxx> wrote in message
>news:ese1TipXFHA.2684@xxxxxxxxxxxxxxxxxxxxxxx
>> yes - although the SBSMONITORING and SHAREPOINT instances are
>> automatically updated to SP4 during the SBS SP1 installation, unless
>> you've upgraded the SHAREPOINT instance to SQL (ie the MSDE/WMSDE
>> instances are automatically upgraded).
>> In addition, there is no need to upgrade the MSFW database instance as
it
>> is upgraded during the installation of ISA 2004 with SP1.
>> Any other SQL database instances will need to be upgraded manually,
>> provided you've confirmed this is supported by the LOB app.
>>
>> HTH
>>
>> Dean Calvert [SBS-MVP]
>>
>> <dbj> wrote in message news:uNORvTpXFHA.3140@xxxxxxxxxxxxxxxxxxxxxxx
>>> Is it ok to run the SQL service pack 4 against a SBS 2003 premimum
>>> version? I have also just installed SBS 2003 SP1 (it seems to work...)
>>>
>>> Thanks.
>>>
>>> Don
>>>
>>>
>>
>>
>
>
>
.
- References:
- SQL service pack 4 & SBS 2003 premimum version
- From: dbj
- Re: SQL service pack 4 & SBS 2003 premimum version
- From: Dean Calvert [SBS-MVP]
- Re: SQL service pack 4 & SBS 2003 premimum version
- From: dbj
- SQL service pack 4 & SBS 2003 premimum version
- Prev by Date: RE: SBS2003-Two Unconnected Offices, Mail Hosted on ISP
- Next by Date: Re: Excessive queue length in SBS2K3
- Previous by thread: Re: SQL service pack 4 & SBS 2003 premimum version
- Next by thread: SBS2003-Two Unconnected Offices, Mail Hosted on ISP
- Index(es):
Relevant Pages
|
