Re: 20GB Partion C: running out of space

Thank You for your post,
I am not sure what I am suppose to back up.

The directorsy for the .mdf and .ldf are

C:\program files\microsoft sql server\mssql\data
C:\program files\microsoft sql server\mssql$sbsmonitoring\data
C:\program files\microsoft sql server\mssql$sharepoint data

I am using Exchange and the log files are mostly in C:\windows and they are
in other locations as well. I am using sharepoint company we, and was using
the incoming fax service.

I am in dire straits, what can I safely delete pronto to free up space.
Thank You
Mark

"Al Williams" wrote:

20GB is plenty big enough for C, you must have something misconfigured or in
need of a move.

Some questions/comments:

1) What are the directory locations and name/extension of these log files?
SQL data and log files usually use .mdf & .ldf.
2) Are you properly backing up your SQL database? That will cause the log
files to accumulate.
3) Are you using Exchange for email? The same two points above apply to
exchange databases. You must back them up otherwise exchange log files
(.LOG) will accumulate.

You do not need to uninstall anything - both exchange and SQL have ways of
moving database files and log files. With SQL, you simply use the
Enterprise manager to backup and restore the database to the new location.

See the following MS page for help documents and download "Moving Data
Folders for Windows Small
Business Server 2003":

http://www.microsoft.com/windowsserver2003/sbs/techinfo/productdoc/alpha.mspx

--
Allan Williams



"Magnetoram" <Magnetoram@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72095A2F-E200-4B1E-A925-51AFCCC74ED8@xxxxxxxxxxxxxxxx
Hi,
I have SBS 2K3 Premium with SP1 installed on the C drive. I have SQL
installed as well but do not use ISA. I followed Harrys book but made the
partition 20 GB. I am now running out of disk space on C. It is obvious
that
SQL is using the space. I have 1 LOB app that uses SQL but stores most of
there data on D:. Howeve, when I do a search for files with there name I
get
a lot of log files that could be as large as 1,500.000KB. Is there a way
to
change the installation location of SQL without having to uninstall SQL. I
also am concerned how it will affect the LOB app.
Thank You



.

Relevant Pages

  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Problem causing me to have to restore tlogs WITH MOVE
    ... I have a database i am m oving to another server, ... am moving the data and log files to another drive.(Which I have done ... The problem I am having is after I restore the database using the ... TO ?D:\Program Files\Microsoft SQL ...
    (comp.databases.ms-sqlserver)
  • Re: Moving the SQL Database
    ... I think you should reinstall SQL server, you should just move the databases ... and log files to the new partition. ... > I've got SPS2003 installed on the C: with the SQL database on the same ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Proper way to move Log files to another drive
    ... > TEMPDB is heavly accessed for temporary operations like (Order by,, group ... > not required to move those transaction log files to new location. ... Stop and Start SQL Server ... >> the APPS drive, and it created its database, and log file, in the ...
    (microsoft.public.sqlserver.setup)
  • Re: Defragmentation Tools
    ... SQL or Exchange files while they are in use. ... My perfect disk 2008 takes the exchange store offline to defrag it. ... production tuning and maintenance of live database types. ...
    (microsoft.public.windows.server.sbs)