Solved

SBS2008  and SQL

Posted on 2016-08-01
10
79 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Slow Connectivity over ODBC 8 32
I Need a T-SQL Query (Union or Intersect, or...?) 6 39
Loop to go backward 90 days 2 18
T-SQL:  Collapsing 9 19
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

813 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

12 Experts available now in Live!

Get 1:1 Help Now