Solved

Config_Log file keeps growing exponentially, already 4.4Gb

Posted on 2007-11-16
11
557 Views
Last Modified: 2008-09-20
Config_Log file for WSS on SQL 2005 EXpress edition seems to grow exponentially and seemingly without anyway of limiting it's growth. Have tried to get into it with SQL Manager, but it doesn't support remote connections as the remote management libraries are not loaded. Any ideas or thoughts on the issue.
0
Comment
Question by:gweeble1
  • 4
  • 3
  • 2
11 Comments
 
LVL 10

Expert Comment

by:AustinSeven
ID: 20299821
One possible cause of a continiously growing tran log is a long running transaction.   However, the other main cause is more typical...  Not backup up the database and the transaction logs.  You definitely need to find some way of managing that instance of sql server express so solve that problem first.   SQL Express comes with it's own lightweight tool called Management Studio Express so you should be able to use that on the server/desktop on which SQL Server Express was installed.   When you can get access to it via Studio Express or whatever, check that both full bacups and transaction log backups are in place.   Before continuing, you need to confirm this is being done.

AustinSeven
0
 

Author Comment

by:gweeble1
ID: 20299887
Have been backing up with the sharepoint services... SQL Server express was installed by the WSS install
0
 
LVL 10

Expert Comment

by:AustinSeven
ID: 20299949
Hmmm... I don't use WSS so I do not know if you mean the databases are being backed up or not?   Don't assume they are.   You need to see directly.   Once you're in using a tool like Management Studio, you can check out not only if the db relating to WSS is being backed up properly but you can also analyse the tran log to see how that file space is being used.   I've seen big tran logs that just need to be big because of the amount of transactions.   4gb is very big though so my bet is the lack of backups.

AustinSeven
0
 

Author Comment

by:gweeble1
ID: 20300040
Okay I do not have any management studio, MS don't include it in the Windows Sharepoint Services distribution.

I have done backups manually through the Administration web interface.. This is for Sharepoint Services 3.. Like I have said there is no way of connecting to the DB remotely because of the lack of installed management interface and connection libraries..

AustinSeven, thanks for your help, but I think I need someone who has worked with Windows Sharepoint Services 3.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 20304099
I advise the folowing:
> to stop using gui tools for handling this kind of problem (any command tool is fine sqlcmd, osql, query analyzer)
> limit the number of procedural (itterative) approaches in transaction coding and use more set oriented approaches
> reduce rollback segments even if you have massive update/delete/insert transactions
> shrink files and/or database sizes using dbcc shrinkfile/shrinkdatabase

Hope this helps...
0
 

Author Comment

by:gweeble1
ID: 20304614
Racimo, thanks, but I will need some pointers in the right direction for walkthroughs and stuff, I am a newbie to the first thing you mention, although I have used SQl before and understand the basics Select, INsert, Where.

But the last three I am not sure I know where to start.. This is a tiny sharepoint installation and the main content database is less than 60 Mb, but just can't understand why the transaction log keeps growing.. and growing... and growing...

Experts Exchane is my last hope before I call Microsoft and have to pay a fortune for someone to assist.

Guy
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 20305352
Whether I would like it or not, I can't teach in one thread what takes years of practice to master...TSQL is not just querying language for selects, update, and delete but also a querying language that gives access to powerful maintainance function that you may call using command line client such as osql, isql (and sqlcmd for SQL2005 boxes).  They are executable that you may generally find by doing a search in the binary partition of the server.  You can then enter command lines such as dbcc shrinkfile the same way you would enter regular select's.  Here is the official  MS link

http://msdn2.microsoft.com/en-us/library/aa258824(SQL.80).aspx

I suggest you seriously consider a training onto administration through TSQL.

Hope this helps...
0
 
LVL 10

Accepted Solution

by:
AustinSeven earned 500 total points
ID: 20311229
gweeble1,

This isn't an issue with WSS as such and the fist step in your solution is to find out what is actually hgappening with the backups, by side-stepping WSS.   SQLCMD was mentioned.  You could use that.   However, I have to disagree with your idea that you can't get a management GUI working.   As you're not experienced with this stuff, a management GUI is essential.    All difficult tasks break down into smaller and easier tasks - divide and conquer.   First objective is to get a management tool in place so you can analyse what's going on.   It might raise more questions but at least you'll then be able to post some specific questions that can be answered here.  

AustinSeven
0
 

Author Comment

by:gweeble1
ID: 20321511
Hi, getting below error while trying to backup the big file says that the name of the database is incorrect

USE MASTER
EXEC sp_addumpdevice 'disk', 'SS_CONFIG_AE', 'H:\backup\DSESVR\SHAREPOINT\SS_CONFIG_AE.dat'

backup database SharePoint_Config_ae2cfb3b-35c3-4625-b677-936b57f61df3 to SS_CONFIG_AE


Server: Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '-'.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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 setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 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

13 Experts available now in Live!

Get 1:1 Help Now