Re: Installing WSS with the WMSDE installed to D: instead of C:

From: Margaret Wilson (twokatmew_at_nospam.msn.com)
Date: 05/18/04


Date: Tue, 18 May 2004 12:37:39 -0400

OK, I've tested this, and here's how it works:

Even though you might specify the data dir as "d:\spoint\" for example,
setup still creates a subdirectory within your data dir called
"MSSQL$SHAREPOINT" and then creates its various subdirectories within that.
*All* databases are in this data directory, including master, tempdb, etc.

If, when you specify your data directory, you leave off the second
backslash, setup creates a directory named d:\spointMSSQL$SHAREPOINT (using
my previous example). If you specify "d:\\" as the data directory, all
WMSDE data gets created in d:\MSSQL$SHAREPOINT.

You can find the "setupsts.exe" file by manually extracting the files from
the sharepoint install exe, STSV2.EXE. To do this, you'll need to run STSV2
with the /t and /c switches. For more information run STSV2 with the /?
switch.

Once the files are extracted, you can run SETUPSTS.EXE with /?, but the
/datadir switch is not documented. There are two *.htm files that also get
extracted, setup.htm and stsread.htm. Neither of these files document the
/datadir switch either.

Hope this info helps,

Regards,

Margaret

--
Margaret Wilson, MCSE
Health Information Technology
Michigan State University
"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:%23tEbGyzOEHA.736@tk2msftngp13.phx.gbl...
> There was a recent thread that I can no longer find where we (mainly me)
> went in circles about how to install WSS so that the default database is
> installed on D:. It was a case where my experience with STS proved
> completely wrong and all we ended up with was install to C: and then use a
> KB article to move the database.
>
> Well there's a better way and it's very clearly spelt out in the WSS User
> Guide.
>
> *********
> Install Windows SharePoint Services specifying the location of the WMSDE
> database
>
> If you want to specify the location to install the WMSDE database, use the
> /datadir= option with the setupsts.exe command line tool.
> The syntax is as follows:
> setupsts.exe /datadir="path\\"
>
> For example, to install the WMSDE database to the d:\program
> files\wmsdedata\ directory, type the command:
> setupsts.exe /datadir="d:\program files\wmsdedata\\"
> ********
> (The next longer paragraph gives even more information)
>
>
> Apologies for the mess-up in the first post!
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at wss.collutions.com
> Please post questions to the newsgroup only.
>
>


Relevant Pages

  • Hey I think I found where you can specify location of SSEE database...
    ... the database goes if you choose to do a standalone or basic install of WSS ... specify what partition, drive, whereever you want the local database to go. ... step through the help files that are available only during install and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Hey I think I found where you can specify location of SSEE database...
    ... the database goes if you choose to do a standalone or basic install of WSS ... specify what partition, drive, whereever you want the local database to ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Problem with MSDE installing.
    ... > The default install should not ask you to specify the database because the ... > Mike Walsh, Helsinki, Finland ... >> but asking me to specify the database. ...
    (microsoft.public.sharepoint.windowsservices)
  • talking to msde 2k from java
    ... I am completly new to sql servers. ... installed on my machine (however i did not install it so can't tell ... I have been doing my work on the database with the web admin tools, ... If i do not specify a db and use the sa username, ...
    (microsoft.public.sqlserver)
  • Re: Import Text with existing schema.ini file utility
    ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
    (microsoft.public.access.modulesdaovba)