Avatar of nacha9817
nacha9817
Flag for Singapore asked on

Full Farm backup of Sharepoint 3.0

Hello Sir,

I notice that my sharepoint_config log file is quite huge (14GB). Could i use the "Central Administration" to do a full farm backup in order to somewhat reduce the log file as i am running low on disk space.

I'm running Microsoft Sharepoint 3.0 with the built-in Microsoft SQL Server 2005 Express Edition.

My Sharepoint data path is C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

Thank you in advance.
Microsoft SharePoint

Avatar of undefined
Last Comment
nacha9817

8/22/2022 - Mon
Jamie McAllister

Use the DBCC Shrinkfile command in SQL Server to shrink the log file size. It's not a backup that's causing this.

http://support.microsoft.com/kb/907511
nacha9817

ASKER
Hello Jamie,

Thank you for your reply. I have read the link you provide but i would like you to know also that i am no SQL or DB administrator. I am totally at lost when comes to databases  & SQL. Nevertherless i still need to maintain my company server which in my case have Microsoft Sharepoint Services 3.0 installed.

Could you help me how to get into the "Transact-SQL" mode so that i can try to run the commands.

It looks like there are 2 steps involve. First is to do a backup of the log file and second is to shrink the log file itself. Since my log file is approx 14GB, can i set my "targetsize" to 1GB?

Thanks again.
SOLUTION
Jamie McAllister

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
nacha9817

ASKER
Yeah..that's what i like..mouse click. I've read somewhere that i could download the SQL Server Management Studio to do backup of the database but i have not tried it. Since now that you have enlighten me i shall download and try to shrink the log file.

If you don't mind, could you give me the link to download the free version of SQL Server Management Studio.

Thank you very much & i will keep you posted once i have try out.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
nacha9817

ASKER
I think i found the link.

http://www.microsoft.com/en-us/download/details.aspx?id=8961

Thks and will update the outcome soon. Cheers!
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jamie McAllister

Good work!

No luck with the DBCC Shrinkfile command either then?
nacha9817

ASKER
I did not try the DBCC shrinkfile command coz i prefer mouse click..haha.
Thank you for your valuable input & i have manage to reduce the config_log file.

Cheers!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
nacha9817

ASKER
I've requested that this question be closed as follows:

Accepted answer: 0 points for nacha9817's comment #38025635

for the following reason:

With the help of Jamie i manage to solve the problem. With his inputs i could try out a few things he suggested and in the end problem was resolved though the procedure i went thru may not be in the right order. Just wondering if Sharepoint 3.0 Central Administration Full Farm backup will actually shrink the log file for you.
Jamie McAllister

Hi nacha9817

I'm glad my assistance helped you resolve it. All the things suggested are likely to be of help to other users in future. Maybe you could award some points rather than deleting the question?
nacha9817

ASKER
Hi Jamie,

I'm new to Expert-Exchange. How do i reward points?

Thks
Your help has saved me hundreds of hours of internet surfing.
fblack61
Jamie McAllister

Scroll to the comment in the thread that best answers the question and click the Accept as Solution link.

http://vimeo.com/35720633
nacha9817

ASKER
Sorry i confused on how to closed the question. I may not be awarding points to Jamie and that's not fair coz with his inputs i solved the problem. If i am correct i need to select "multiple solutions" in order to reward points as i include my comments as solutions too.

Hopefully after i click the "Object" button i could go back and award points to Jamie.
nacha9817

ASKER
Hope this works!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.