Re: Location of Data

From: Bill Williams (DHL) (BillWilliamsDHL_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 16:59:02 -0700

> 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
> >
>
>
>

Relevant Pages

  • Re: MSDE OSQL Shutdown
    ... dann den Server herunterfährst könnte genau in dem Moment die Aktion ... Aus Gründen der Datenkonsistenz sollten Datenbanken niemals Offline ... weil alle Backups dazwischen unbrauchbar waren;-) ... Datenbank Verzeichnis des SQL Servers dafür vom Dateibackup aus. ...
    (microsoft.public.de.sqlserver)
  • Re: Location of Data
    ... first install), then you will probably reach a point on your second or third ... Moving Data Flolder for Windows Small Business Server 2003 ... >> 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 ...
    (microsoft.public.windows.server.sbs)
  • Re: Cluster backup
    ... MVP - Windows Server - Clustering ... > My network admin wants to have my SQL backups (performed via. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Log File Bloating - Preventative Maintenance
    ... As long as the SQL service is running you won't get a consistent snapshot of the file contents and the backups will be unusable SQL has a transactionally consistent backup method built-in. ... Transaction log backups are used to "move" a full backup forward to a given point in time for recoverability. ... If once a day recovery is good, then SIMPLE recovery and full backups are fine. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot Open Query analyser from SQL Enterprise Manager
    ... In SQL Enterprise Manager (SEM), go to Tools->External Tools; ... >I get the same problem right after installing MSDE also ...
    (microsoft.public.sqlserver.tools)