Re: Location of Data
From: Les Connor [SBS MVP] (les.connor_at_DEL.cfive.ca)
Date: 09/03/04
- Next message: Bill Glidden: "Re: Installing Software via Terminal Services"
- Previous message: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "Re: software assurance question"
- In reply to: Bill Williams (DHL): "Re: Location of Data"
- Next in thread: Bill Williams (DHL): "Re: Location of Data"
- Reply: Bill Williams (DHL): "Re: Location of Data"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 23:30:54 -0500
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: Bill Glidden: "Re: Installing Software via Terminal Services"
- Previous message: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "Re: software assurance question"
- In reply to: Bill Williams (DHL): "Re: Location of Data"
- Next in thread: Bill Williams (DHL): "Re: Location of Data"
- Reply: Bill Williams (DHL): "Re: Location of Data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
