?
Solved

SBS2008  and SQL

Posted on 2016-08-01
10
Medium Priority
?
113 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 96

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 96

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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 

Author Comment

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

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 96

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 96

Accepted Solution

by:
Lee W, MVP earned 2000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

801 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