Solved

SQL 2008 question

Posted on 2014-03-16
3
174 Views
Last Modified: 2014-03-23
Will SQL2008 work well on a Server loaded SBS2003?
Any issues with installation that I may face & how long should this take to install on
a relatively ok server that barely breaks a sweat.

I am not interested in the configuration aspect as we have someone else doing this side.
 
Also Express has been ruled out as an option.
0
Comment
Question by:citrine
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
rick81 earned 500 total points
Comment Utility
depending on which version of sbs2003 you have it may not be supported.  the O/S support list is here.  http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx

you'll want a heap of available RAM if you are going to run sql2008.  depending on the connected users and the amount of requests on the dbase.
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
http://msdn.microsoft.com/en-us/library/ms143506%28SQL.100%29.aspx#SE32

According to details at link above, in general "SQL Server 2008 (32-bit)" editions work fine on:

"Windows Server 2003 SP2 Small Business Server Standard"
"Windows Server 2003 SP2 Small Business Server Premium"

but not the 64-bit ones.

As far ad how long it takes to install? It all depends on that server hardware resources.

More details at:
http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx
0
 
LVL 6

Expert Comment

by:rick81
Comment Utility
realistically allow a couple of hours to do the install.  if sql requires configuration, installing updates, patches, etc.  probably something you would want to do after hours if the server is in production.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now