Re: Moving MSDE Data store
From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 05/29/04
- Previous message: Mike Walsh: "Re: Simplest way to set up Frontpage Server"
- In reply to: Simon Atkinson: "Moving MSDE Data store"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 29 May 2004 12:18:55 +0300
I'm glad you like the FAQ because I wrote it.
But I hope you'll also like this.
I would recommend before you go any further that you do NOT run STS on
Windows 2003 Server. Although this works, it is not a supported environment.
Also if you have a Windows 2003 Server available, there is little point in
spending time on SharePoint Team Services which is the back version since
Windows SharePoint Services (WSS) came out in October 2003.
There is an even better FAQ (written by ...) there so the FAQ is not a
reason for sticking with STS. There is also much better support in the
microsoft.public.sharepoint.windowsservices newsgroup too. Here almost all
you have is me answering based on my memory of how STS works.
In addition the MSDE version (=WMSDE) that comes with WSS is better than
that that comes with STS as it no longer has performance throttling after 5
concurrent users and also no longer has the 2GB database size limit. What
you lose is Sorting with the MSDE version (which you have even with MSDE
when you run STS.
There's also in WSS a Microsoft paper telling you how to move the database
(!).
In STS I don't know. The best way was always to specify a different drive
for the database *before* you installed.
I see that you don't mind re-installing - if so (and you still insist on
installing STS and not WSS) read the STS FAQ again - it has how to install
on different drives, if I remember.
Mike Walsh, Helsinki, Finland
STS FAQ at www.collutions.com/Lists/FAQ
WSS FAQ at wss.collutions.com
Please reply to the newsgroup
"Simon Atkinson" <me@privacy.net> wrote in message
news:2hpos9FfuautU2@uni-berlin.de...
> Hi All,
>
> Sorry if this is a FAQ - I've read the FAQ (and jolly good it is too)
> and scanned most of the messages here since December without finding
> the answer!
>
> I've just install Sharepoint Team Services onto a 2003 server and it's
> all working nicely. However MSDE seems to default to storing the data
> in C:\program files\microsoft sql server\MSSQL$SHAREPOINT\Data and I
> want it elsewhere - I don't like using the boot drive for data, and
> there isn't too much free space on that drive.
>
> I've messed about with no joy. How can I either move the data folder
> elsewhere (another drive on the same server) or reinstall telling the
> installer to use another drive?
>
> Many thanks for any help - this is driving me potty!
>
> Thanks.
>
>
> --
> Simes
- Previous message: Mike Walsh: "Re: Simplest way to set up Frontpage Server"
- In reply to: Simon Atkinson: "Moving MSDE Data store"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
