Had this problem with SBS 2008 server last week.
The server disk usage was high with no particular reason, the service useing all the disk resources was mssql.exe reading from SBSMonitoring.mdf. READ MORE »
Posts in category MS SQL 2008
SBSMonitoring “heavy disk usage”
How to: shrink an SQL log file.
Once in awhile I meet an sql based program that won’t work or stop respond to client requests until I flush the SQL database log file.
I wanted to create a script so I can run it through the scheduled tasks and get rid of this annoying task.
This is what I needed to do:
To shrink SQL log file on a scheduled base I did the following:
create a text file and change the extension to sql (Example: Shrink_log.sql)
add this lines to the script file: READ MORE »
How to: claim lost space on drive c: under SBS 2008 Part 2
In my previous post “How to: claim lost space on drive c: under SBS 2008” I have mentioned the obvious things that can be done to free space from drive C: on an SBS 2008 server.
Today I discovered another fast growing and space consuming service, sharepoint…or to be precise,the SharePoint Config database Log file located at C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\Sharepoint_config_***.ldf
this file can be huge. READ MORE »
SQL 2008 server backup to a network share, access dined.
I had an odd problem today with an SQL 2008 server backup to a network share.
The maintenance plan that was scheduled to run daily and backup the databases, were falling with an access dined error to the network location for some reason. READ MORE »