Config_Log file keeps growing exponentially, already 4.4Gb

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.
gweeble1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AustinSevenConnect With a Mentor Commented:
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
 
AustinSevenCommented:
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
 
gweeble1Author Commented:
Have been backing up with the sharepoint services... SQL Server express was installed by the WSS install
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
AustinSevenCommented:
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
 
gweeble1Author Commented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
gweeble1Author Commented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
gweeble1Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.