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

From: Mike Roselius (mike_roselius_at_gallup.spam.com)
Date: 05/20/04


Date: Wed, 19 May 2004 19:57:27 -0500

One other issue to concern yourself with - disaster recovery...

If you every need to do a bare metal restore of these databases to a new
server - it is much much easier to accomplish if the recovery server has the
same disk structure as the failed server - i.e. a C:, D: and E: drive or
whatever.

When you restore the master db - it holds the paths to other system
databases - and if they can't reside in the same paths on the recovery
server, it's a bit more challenging.

Just one of those gotcha's that hits only when someone is looking over your
shoulder asking you when the site will be back up :)

"Margaret Wilson" <twokatmew@nospam.msn.com> wrote in message
news:c8de4j08m8@news4.newsguy.com...
> 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

  • Re: NTDS ISAM DataBase Corruption
    ... Did you tried the recover the corrupted Active Directory process that a gave ... This is brand new IBM Server. ... using symantec livestate recovery. ... Active Directory database is unavailable because it is damaged, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Sharepoint not working anymore
    ... a way to rebuild the master database (which you can think of as the database ... Microsoft Small Business Server Support ... SBS Newsgroups: ... >> You mentioned that you had set out to install SP1... ...
    (microsoft.public.windows.server.sbs)
  • Re: Multiple instances
    ... "We wrote the books on Project Server" ... >> install; one production, one demo. ... >> I first created a new project database, populated it by running setupdb, ... >> had MSProjectServerUser in the MSProjectMember Role text box under ...
    (microsoft.public.project.pro_and_server)
  • RE: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)

Quantcast