• Home
  • About
    • Disclaimer
  • Archives
  • Tools

Posts in category MS SQL 2008

SBSMonitoring “heavy disk usage”

Jan22
2012
Written by david

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 »

VN:F [1.9.20_1166]
please wait...
Rating: 10.0/10 (2 votes cast)
VN:F [1.9.20_1166]
Rating: +3 (from 3 votes)
Posted in SBS 2008 - Tagged SBS 2008

How to: shrink an SQL log file.

Dec24
2011
Written by david

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 »

VN:F [1.9.20_1166]
please wait...
Rating: 8.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: +3 (from 3 votes)
Posted in Command Line, How To:, Windows - Tagged CMD, How to

How to: claim lost space on drive c: under SBS 2008 Part 2

Jul01
2011
Written by david

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 »

VN:F [1.9.20_1166]
please wait...
Rating: 10.0/10 (3 votes cast)
VN:F [1.9.20_1166]
Rating: +1 (from 1 vote)
Posted in SBS 2008 - Tagged SBS 2008, Sharepoint

SQL 2008 server backup to a network share, access dined.

Jun09
2011
Written by david

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 »

VN:F [1.9.20_1166]
please wait...
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)
Posted in Windows - Tagged windows

Categories

  • Command Line (11)
  • Exchange (8)
    • 2007 (4)
    • 2010 (5)
  • Fortigate (10)
  • FreeNAS (2)
  • HmailServer (1)
  • How To: (8)
  • MS SQL 2008 (4)
  • Networking (4)
  • Open Source (1)
  • PowerShell (2)
  • Recovery (1)
  • SBS (8)
    • SBS 2008 (6)
    • SBS 2011 (3)
  • Terminal Server (2)
  • Veeam (2)
  • VMware (6)
  • Windows (18)

Links

  • חי הדפסות – דפוס משי, חולון
  • שלישיה – זה לא מה שחשבתם

Archives

  • March 2018
  • January 2018
  • September 2015
  • January 2015
  • August 2014
  • May 2014
  • December 2013
  • January 2013
  • October 2012
  • September 2012
  • July 2012
  • June 2012
  • May 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
Site Meter

EvoLve theme by Theme4Press  •  Powered by WordPress How to do.....IT