Re: Move Built in SBS Databases (Monitoring, Sharepoint) to SQL Se

Hi,

For your question, "Is it posible to move built in SBS databases
(Monitoring in example) to a SQL server Express edition?" I'd like to give
you the following suggestions:

The answer is NO.

By default, the monitoring WMSDE instance cannot be upgraded to SQL 2000
server or later version.

For the Sharepoint WMSDE instance, it can be upgraded to SQL 2000 server or
SQL Server 2005 Workgroup Edition. However it is not supported to upgrade
to SQL Server 2005 Express Edition due to different basic structure.

To upgrade Sharepoint WMSDE instance to SQL 2000 server or SQL Server 2005
Workgroup Edition, you can refer to the following articles:

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

How to upgrade the initial release of Windows Small Business Server 2003 R2
to include the final release version of SQL Server 2005 Workgroup Edition
http://support.microsoft.com/kb/924000

Help the information helps.

If you need further assistance, please don't hesitate to let me know.

Best regards,

Robert Li(MSFT)

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.

--------------------
<From: "Kevin Le" <kevinle@xxxxxxxxxx?subject=Regarding%20Your%20Post>
<References: <DB15D786-0D06-43AF-BCBA-C1DB123F2E20@xxxxxxxxxxxxx>
<#EgSw7K0HHA.3536@xxxxxxxxxxxxxxxxxxxx>
<uFtbPJL0HHA.464@xxxxxxxxxxxxxxxxxxxx>
<ufxwA0M0HHA.5160@xxxxxxxxxxxxxxxxxxxx>
<36A5A3BE-33B2-4138-8139-0C851A4A09E0@xxxxxxxxxxxxx>
<In-Reply-To: <36A5A3BE-33B2-4138-8139-0C851A4A09E0@xxxxxxxxxxxxx>
<Subject: Re: Move Built in SBS Databases (Monitoring, Sharepoint) to SQL Se
<Date: Mon, 30 Jul 2007 15:39:34 -0500
<Lines: 57
<Message-ID: <BF7D57FE-3DD8-4FB6-93EA-4527140A30FA@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< format=flowed;
< charset="utf-8";
< reply-type=original
<Content-Transfer-Encoding: 7bit
<X-Priority: 3
<X-MSMail-Priority: Normal
<X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
<X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
<X-MS-CommunityGroup-PostID: {BF7D57FE-3DD8-4FB6-93EA-4527140A30FA}
<X-MS-CommunityGroup-ThreadID: DB15D786-0D06-43AF-BCBA-C1DB123F2E20
<X-MS-CommunityGroup-ParentID: 36A5A3BE-33B2-4138-8139-0C851A4A09E0
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:53404
<NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<This might help
<
<http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx#
ESHAC
<
<
<"kacoquico" <kacoquico@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
<news:36A5A3BE-33B2-4138-8139-0C851A4A09E0@xxxxxxxxxxxxxxxx
<> Any link to a step by setp or guidelines to perform this migration ?
<>
<> Many thanks
<>
<>
<>
<> "bass_player [SBS-MVP]" wrote:
<>
<>> Looks like MS is competing with the other database engines like DB2 and
<>> Oracle which also provied the express versions. They've increased the
<>> limit
<>> from 2GB to 4GB. Thanks for the tip ;-)
<>>
<>>
<>> "SuperGumby [SBS MVP]" <not@xxxxxxxxxxx> wrote in message
<>> news:uFtbPJL0HHA.464@xxxxxxxxxxxxxxxxxxxxxxx
<>> > http://www.microsoft.com/sql/editions/express/features.mspx
<>> >
<>> > Scalability and Performance
<>> > .Supports 1 CPU, but can be installed on any server
<>> > .1 gigabyte (GB) addressable RAM
<>> > .4 GB maximum database size
<>> >
<>> >
<>> > "bass_player [SBS-MVP]" <bass_player@xxxxxxxx> wrote in message
<>> > news:%23EgSw7K0HHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
<>> >> Yes it is possible but be aware of the maximum database size for SQL
<>> >> Server 2005 Express - 2GB. SBSMONITORING should stay in MSDE.
though.
<>> >> I
<>> >> wouldn't move Sharepoint to Express due to this limitation
<>> >>
<>> >>
<>> >> "kacoquico" <kacoquico@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
<>> >> news:DB15D786-0D06-43AF-BCBA-C1DB123F2E20@xxxxxxxxxxxxxxxx
<>> >>> Is it posible to move built in SBS databases (Monitoring in
example)
<>> >>> to
<>> >>> a SQL
<>> >>> server Express edition?
<>> >>>
<>> >>> If so any link to how to do it?
<>> >>>
<>> >>
<>> >>
<>> >
<>> >
<>>
<>>
<>>
<>
<
<

.

Relevant Pages