SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - Setup, Upgrade, Administration and Operation
>
Data base size is increasing quickly.
Data base size is increasing quickly.
In my sharepoint WSS3 server the following files are increasing by its size quickly ,
C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
1. WSS_Search_SHAREPOINT_log.LDF
2. WSS_Content_log.LDF
Anybody can help me to find a solution for this issue.
Thanks,
Aji
Answers
You have to download the SQL Express tools seperately and onnect to the instance.
Routine backup and or maintenance plans will help keep your log size down.
All Replies
- The log files do increase to be quite large since we do cloaning on our sharepoint farm we changed them to simple backup I belive our DBA called it and are log file shrank exponentially from 75 GB to 8 MB in some cases.
But my sql server is 2005 Embedded edition, how can I connect to it....
You have to download the SQL Express tools seperately and onnect to the instance.
Routine backup and or maintenance plans will help keep your log size down.
Use this connection string in SQL Server Manager:
\\.\pipe\mssql$microsoft##ssee\sql\query
- Although one of these files is a Search file, I'm moving it to the Admin forum as it's really not a Search question.
- Thank you all,
I got help from my DBA team to shrink the files. Sorry for the late reply.
Thanks,
Aji Jose
Sharepoint Admin - Hi,
I have the same issue.. Logfile is getting bigger and bigger.. What did you do to gett the ldf smaller?
@all other: Is there a general best-practise?
- Excellent....thanks
