Solved

SBS2008  and SQL

Posted on 2016-08-01
10
71 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

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

Expert Comment

by:Lee W, MVP
Comment Utility
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
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.

 

Author Comment

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

Expert Comment

by:Lee W, MVP
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks for your prompt helo
Sam
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now