Re: SQL on its own partition

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Joe,

Thanks for posting in our newsgroup.

Usually is recommended installing everything on the C drive during the SBS
2003 Integrated Setup and then moving some of the data such as Exchange
Database Files to the other drive. We have a white paper discussing moving
data in SBS 2003, you can take a look at the following URL for reference:

Moving Data Folders for Windows Small Business Server 2003
http://www.microsoft.com/downloads/details.aspx?FamilyID=A1D0AF69-1287-4225-
BD8B-59C89F44984B&displaylang=en

For SQL and ISA, you can choose to store the database files and cache
folder in another driver during the installation.

Hope above 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: "Henrik" <henrik@xxxxxxxxxxx>
<References: <B39965FF-E0D8-40EF-BE65-53383DC689E4@xxxxxxxxxxxxx>
<1176769834_19419@xxxxxxxxxxxxxxxxxxxx>
<44D2DC48-6D4B-4AF2-8A8C-32052BC76AD2@xxxxxxxxxxxxx>
<1176773520_19547@xxxxxxxxxxxxxxxxxxxx>
<E638BA00-6D49-48BC-B8C6-E258F0247EA0@xxxxxxxxxxxxx>
<1176778038_19651@xxxxxxxxxxxxxxxxxxxx>
<Subject: Re: SQL on its own partition
<Date: Tue, 17 Apr 2007 09:28:23 +0200
<Lines: 78
<X-Priority: 3
<X-MSMail-Priority: Normal
<X-Newsreader: Microsoft Outlook Express 6.00.3790.2826
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<X-RFC2646: Format=Flowed; Original
<Message-ID: <#a8B9HMgHHA.4872@xxxxxxxxxxxxxxxxxxxx>
<Newsgroups: microsoft.public.windows.server.sbs
<NNTP-Posting-Host: ua-83-227-148-196.cust.bredbandsbolaget.se
83.227.148.196
<Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:30642
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<Hello,
<
<By the default installation of SBS 2003 your various different instances
of
<datadases are installed on C: .
<That means if you havent changed It during the installation process.
<
<When you install SQL server with SBS 2003 (Premium Ed.) you along the MSDE
<instaces of WSUS, Monitoring etc. also gets a default instance in SQL
<server.
<You can se all your installed instances in add/remove program.
<
<When you install SQL server (This does not automaticly means all other
<instances such as WSUS, Monitoring etc) you can during setup choose where
to
<install it.
<If you install It on D: you still have some program (SQL) files on C: but
<the default databases are placed on the partition you chose. There are
some
<databases in SQL that comes by default and that has to be there. The
chosen
<partition are also the place for the primary file group in SQL where any
<other database that you install also are placed. That means if you
<application that uses SQL doesnt needs its own instance name. If it does
you
<have to run the SQL server setup an additional time and during that setup
<chose to install a new NAMED instance.
<
<Regarding performance, its vital if you want good performance, to place
<datafiles on separate discs from the trans-log files.
<For good performance, also separate both datafiles and trans-log files
from
<the system disc so it wont fight the virtual memory file for disc access.
<Recomended is that you also seperate datafiles and trans-log files from
the
<default databases and files regarding discs so it wont have to figt them
<either for disc acces.
<
<Raid levels. When talking about Raid with SQL best practise is otften to
use
<Raid 10 but it costs moore disc space so the next is to use simple
mirrored
<Raid.
<Raid 5 will give you worse performance. Its all about the amount of
<spindles/disc heads.
<
<In your case, add an additional disc so that you have 6 discs at least and
<then cretae three mirrored drives. One for the system, one for SQL
datafiles
<and SQL default databases ,one drive for tranaction logs to all other
<databases that are not default SQL databases (cant be moved easily).
<
<There is one other BIG issue about seperating trans-log files from the
<databases, that is security in case of disaster. This solution gives you a
<better possibility to recover from a disaster with a minimal of data loss.
<
<//Henrik
<
<"Leythos" <Void@xxxxxxxxxxx> wrote in message
<news:1176778038_19651@xxxxxxxxxxxxxxxxxxxxxxx
<> On Mon, 16 Apr 2007 19:04:03 -0700, JD wrote:
<>
<>> Yes, It is a Dell server with the perc 5i controller. 2 drives are raid
1
<>> and
<>> 3 drives are raid 5 as you descrided.
<>>
<>> The installation instruction on the SQL disk seen to imply you have to
<>> upgrade the SHAREPOINT instance of WMSDE. You are saying it can be left
<>> alone
<>> if you wish?
<>>
<>> The install defaults to the C:\Program Files\Microsoft SQL Server folder
<>> where the MSDE desktop engine is installed. Won't it over ride that
<>> install??
<>
<> No, I'm not telling you anything about the WMSDE, I'm the wrong person to
<> ask about that.
<>
<> I'm only talking about the SQL instance you install for your own
<> databases, not he default ones.
<>
<>
<>
<> --
<> Leythos
<> spam999free@xxxxxxxxxx (remove 999 for proper email address)
<
<
<

.

Relevant Pages

  • Re: Worst monday of my life - please help...
    ... If that's the case, restoring the SQL ... but it finally did install with a few hiccups. ... >> or just leave the mirrored drives in the server on the secondary IDE ... I decided it was time to re-add the mirror. ...
    (microsoft.public.windows.server.sbs)
  • Re: Location of Data
    ... > first install), then you will probably reach a point on your second or third ... > Users Shared Folders (command line) ... > Sharepoint Databases ... >> True I can arrange that, but I was more worried about the SQL data filling ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint SQL upgrade
    ... SQL is on the C drive and the databases are not. ... You probably will want to install SQL 2000 SP4 at this point. ... if you have SBS 2003 Premium Edition you may want to order the SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Query Design View Application Error
    ... >I have no problem opening up existing databases and creating new ones. ... How are you updating to SP3? ... I know my attempts to install SP3 on SQL Server ...
    (microsoft.public.access.queries)
  • Re: Moving SQL 2000 to different Drive
    ... Where did you install SQL Server? ... If on the old drives, ... Ron Talmage ...
    (microsoft.public.sqlserver.server)