Solved

SBS2008  and SQL

Posted on 2016-08-01
10
89 Views
Last Modified: 2016-08-01
We are running out of space on the C:\ drive of our SBS2008 server and the biggest culprit that I dont know how to move or delete is in the  Microsoft SQL server where there are to very large folders SBSmonitoring.mdf and SBSmonitoring_log.ldf
Please can I delete these and stop them from getting big again?
Please see attached picturescan of space used on c driveThanks
Sam
0
Comment
Question by:samcory
  • 5
  • 5
10 Comments
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41737892
If you're running out of space, show us the ENTIRE disk view in TreeSize or WindirStat.

The SBS Monitoring stuff helps alert you to problems on your network.  You can MOVE the databases to another drive, but honestly, they would not be my first priority - 4GB is relatively small.  What else is taking up space and how big is the drive to begin with?
0
 

Author Comment

by:samcory
ID: 41737928
I have moved everything I can and I need to get the email working in a hurry, I will purchase a larger C: drive but in the meantime 4gb is enough to get email downloading again.
Please kindly tell me how to move the sql files (I have no experience of SQL) we have tons of space on our data drive
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41737957
I checked over your question history and don't see where you asked for help cleaning up the C: drive.

You clearly want to do what you want to do, but if you want help solving your root problem let me know and answer my previous questions about what's taking up the space and how large the drive is.

you can find instructions here:
http://it.gamerz-bg.com/index.php/category/windows-server/windows-sbs/windows-sbs-2011/
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:samcory
ID: 41737986
The C: drive is 70gb see attached for use
server2.png
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41737999
What's in Program Files (not Program Files (x86))?  I just checked my last remaining SBS 2008 server and it's Program Files folder is 2 GB.  Yours is 23.  HUGE difference.
0
 

Author Comment

by:samcory
ID: 41738026
The culprit seems to be 1st storage group log files
server3.png
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41738055
It would appear you never moved your exchange databases off the C: drive.  Or your logs.  Have you been performing regular backups to truncate the Exchange logs?  If so, then move the Exchange Databases off the C: drive.

See the instructions here and DO perform a FULL backup first (it's generally a very safe procedure, but you never know when you have a weird situation).
http://www.buchatech.com/2010/10/move-exchange-2007-stores-logs-to-a-different-disk/
0
 

Author Comment

by:samcory
ID: 41738073
We use Carbonite Server Backup so this obviously does not clear the logs -  what to do?
0
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 500 total points
ID: 41738095
First, perform a full server backup using the Windows Backup software (note: most external drives these days are not compatible with Windows Server Backup so you may have to find a workstation with enough disk space and perform the backup saving it over the network on another computer.

That should clear the logs.

Then change the location of the logs.

Finally, change to an Exchange Aware backup *OR* periodically perform a full Windows Server backup to truncate the logs.

Note: if you haven't been keeping the server AND EXCHANGE patched appropriately, you may have problems using Windows Server Backup to clear the logs.  Exchange needs to be at Service Pack 3 (I think) or later to have Windows Server Backup support it properly.

More information and instructions: https://technet.microsoft.com/en-us/library/ee221177(v=exchg.80).aspx
0
 

Author Closing Comment

by:samcory
ID: 41738103
Thanks for your prompt helo
Sam
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question