Re: Location of Data
From: Bill Williams (DHL) (BillWilliamsDHL_at_discussions.microsoft.com)
Date: 09/03/04
- Next message: Marina Roos [SBS-MVP]: "Re: Sharepoint Server Services"
- Previous message: Marina Roos [SBS-MVP]: "Re: Move SBS 2003 to new hardware"
- In reply to: Les Connor [SBS MVP]: "Re: Location of Data"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 12:33:06 -0700
Brilliant, thanks!
I only get two shots at this system. It is a new system for a charity. I've
made it clear that I have to investigate all the issues relating to providing
the best & most relevant service that SBS can provide to them. Then I plan
to do a clean re-install and work through all the procedures that I've
determined are relevant.
Best regards
Bill
"Les Connor [SBS MVP]" wrote:
> Hi Bill,
>
> You have the desktop variety of sql by default, it's used by monitoring and
> companyweb (sharepoint).
>
> You can move all the data files, and more. You need to follow the
> instruction in the white paper:
>
> <snip>
> If you end up going 'bog standard' (which is probably a very good idea on a
> first install), then you will probably reach a point on your second or third
> install where you'll have some real good ideas of how you want to set the
> box up. That third install would probably be intended as the production
> install.
>
> Anyway, even if you go bog standard on your production install, here's
> everything you need to move the growth (data) items onto a separate
> disk/partition.
>
> Moving Data Flolder for Windows Small Business Server 2003 (download)
> http://www.microsoft.com/downloads/details.aspx?FamilyID=A1D0AF69-1287-4
> 225-BD8B-59C89F44984B&displaylang=en
>
> The paper contains instructions for moving:
>
> Users Shared Folders (command line)
> Sharepoint Databases (command line)
> Monitoring Databases (command line)
> Sent Faxes (wizard)
>
> For moving Exchange logs and database (GUI), and Clientapps (regedit
> required), there are no instructions - the KB articles are referenced.
>
> How to Move Exchange Databases and Logs in Exchange Server 2003
> http://support.microsoft.com/default.aspx?scid=kb;[LN];821915
>
>
> How to move the client programs folder to another location in Windows
> Small Business Server 2003
> http://support.microsoft.com/default.aspx?scid=kb;[LN];830254
>
> It's all quite tedious, but I've been through the entire process and it
> all works.
>
>
> --
> Les Connor [SBS MVP]
> -------------------------------------
> SBS Rocks !
>
>
>
> "Bill Williams (DHL)" <BillWilliamsDHL@discussions.microsoft.com> wrote in
> message news:830034E9-BBA8-470E-836E-21427160F07F@microsoft.com...
> >> As far as SQL backups, use SQL Enterprise manager to do at least daily
> >> backups to your D drive and then let your Backup program bakup the SQL
> >> .bak
> >> files
> >
> > True I can arrange that, but I was more worried about the SQL data filling
> > up the smallish system partition eventually, hence the desire to move the
> > SQL
> > data to D:
> > The idea of a system partition is so that it doesn't grow (much), doesn't
> > change much and therefore doesn't need backing up very often.
> >
> > I'm still puzzled as to what SQL server is there.. is it the full thing or
> > is it the cutdown MS Data Engine. I note that Sharepoint stuff uses it,
> > but
> > it isn't done by any conventional ODBC settings. There's an icon for SQL
> > in
> > the system tray, but no 'services' connected.
> >
> >
> >
> > "Frank McCallister" wrote:
> >
> >> Hi Bill
> >>
> >> My big complaint with Dell installs is this exact issue. I always
> >> reinstall
> >> on Dells immediately and set the defaults for Users and Data to D to
> >> avoid
> >> the moving issue. It doesn't take that long and avoids mistakes in the
> >> move
> >> process. Besides if this is your first install of SBS and you intend to
> >> do
> >> more, reading the getting started on CD1 and doing a fresh install will
> >> be a
> >> good learning experience.
> >>
> >> As far as SQL backups, use SQL Enterprise manager to do at least daily
> >> backups to your D drive and then let your Backup program bakup the SQL
> >> .bak
> >> files
> >>
> >> In my opinion you should use the SBS Backup program which uses Shadow
> >> copy
> >> to backup exchange and do a Total on a Daily basis. This clears your log
> >> files and gives you a much better restorable backup.
> >>
> >> Frank McCallister
> >> COMPUMAC
> >> "Bill Williams (DHL)" <Bill Williams (DHL)@discussions.microsoft.com>
> >> wrote
> >> in message news:0D96703F-656D-4ABE-BFF3-8AB93D0C8982@microsoft.com...
> >> >I am experienced in Win2000 server, but this is my first install of
> >> >SBS2003.
> >> >
> >> > Dell have supplied the server and SBS2003 is preinstalled. They divided
> >> > the
> >> > virtual volume into 2 partitions one of 12Gb for the system and the
> >> > rest
> >> > (around 148Gb) for data; a sensible arrangement which worked well with
> >> > Win2KS.
> >> >
> >> > However Drive D: was completely empty, so the initial installation by
> >> > Dell
> >> > did nor relocat any of the Data folders to D:\. I have determined how
> >> > to
> >> > move the "Users Shared folders" to D: and define the correct
> >> > permissions
> >> > etc.
> >> >
> >> > What I need to know is:
> >> > (1) Where is the Exchange Server data and how do I move it from C: to
> >> > D:
> >> > to
> >> > operate from D: ?
> >> > (2) Is there any data in the SQL server database, how do I find the
> >> > database
> >> > and how do I move it to run from D: ?
> >> > (3) Is there any way to move InetPub from C; to D:
> >> >
> >> > Secondary questions.
> >> >
> >> > How do I do incremental backups of Exchange Server data and SQL server
> >> > data?
> >> >
> >> >
> >> > Regards
> >> > Bill
> >> >
> >>
> >>
> >>
>
>
>
- Next message: Marina Roos [SBS-MVP]: "Re: Sharepoint Server Services"
- Previous message: Marina Roos [SBS-MVP]: "Re: Move SBS 2003 to new hardware"
- In reply to: Les Connor [SBS MVP]: "Re: Location of Data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
