Solved

SBS2008  and SQL

Posted on 2016-08-01
10
100 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

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 needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

730 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