?
Solved

Uninstall SQL before Transition Pack

Posted on 2006-04-29
5
Medium Priority
?
270 Views
Last Modified: 2010-04-19
I am planning on using the transition pack on the SBS server to move it to a Win2003 Standard.  I currently use SBS 2003 SQL for our sharepoint servies.   I do not use SQL for anything else but Sharepoint Services so i was wondering if i could just uninstall SQL and used MSDE for Sharepoint Services.  

I do not want to purchase the full SQL license so that is why I do not want it when i transition.  Exchange is already on another server so that is no problem.

Also, if this is possible does anyone know how to switch sharepoint to MSDE from SQL.

Thanks for all the help.
0
Comment
Question by:dbrosnan
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 16570502
To clarify... are you sure that you are using SQL for SharePoint?  That would mean that you have SBS 2003 PREMIUM edition.  

So, are you saying that you want to buy the Standard version of the Transition Pack instead of the Premium Version?  While it's not a FULL SQL license, it is more expensive.

You can do that, but you will need to move back to MSDE and uninstall SQL (and ISA if you have that installed) before using the transition pack.  Moving back to MSDE would only entail backing up your Sharepoint Databases and then restoring them.  You can follow this KB article:  http://support.microsoft.com/kb/829113

If you do not have the PREMIUM version of SBS, then SharePoint is already using MSDE (actually it uses WMSDE which is a version of MSDE that doesn't have a 2GB size restriction).

Jeff
TechSoEasy

0
 

Author Comment

by:dbrosnan
ID: 16574987
It is SBS 2003 Standard.  However, in add/remove programs it lists:
"Microsoft SQL Server Desktop Engine (SBS Monitoring)"
"Microsoft SQL Server Desktop Engine (Sharepoint)"

What I'm worried about is when I use the transition pack will I lose my current Sharepoint http://companyweb web?  

Other than that is there anything else I should worry about when transitioning?

Appreciate the help.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 2000 total points
ID: 16576414
Okay, that is not SQL server, it's MSDE (Microsoft SQL Desktop Engine), which is a lighter version and is included as part of Sharepoint Services installation.  This is a free product... so you wouldn't have had to purchase a SQL license anyhow.

Just follow the steps listed here:  http://sbsurl.com/transition it's fairly straightforward... and it does stress that your first step is to run a FULL backup which should be verified before moving on.

You are going to lose SBS Monitoring... since you're dropping the SBS platform, by the way.  You won't lose your companyweb... but if you want to be double sure that it's backed up, you just need to have copies of the four database files:

• STS_Config.mdf
• STS_Config_log.ldf  
• STS_ServerName_1.mdf
• STS_ServerName_1_log.ldf
 
Copy those off to a USB hard drive or just to a workstation's hard drive just to be safe.  Additionally, you can use the FrontPage Backup procedure as described in the article I linked above.

Jeff
TechSoEasy
0
 

Author Comment

by:dbrosnan
ID: 16578005
Thanks for all of the help.
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 16589250
No prob.  Good Luck!

Jeff
TechSoEasy
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Integration Management Part 2
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question