Full Farm backup of Sharepoint 3.0

nacha9817
nacha9817 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
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

Author

Commented:
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.
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014
Commented:
First off, if you have SQL Server Management Studio installed you can get results sometimes with a few mouse clicks.

Go to the Management Studio and expand Databases on the left side.

Right click on your database and choose Tasks -> Shrink -> Database (you can also do it again for Files afterwards).

Click OK in the screen that comes up, and this may reduce the log file sizes for you, though sometimes it stubbornly refuses. :)

Beyond this, you can also right click on the database and select New Query. This would allow you to paste some T-SQL in a window and execute it to do the shrink.


A target size of 1Gb is fine.
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
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.

Author

Commented:
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!
Hi Jamie,

I have manage to "shrink" the sharepoint_config log file. But i kinda do it in the "reverse" order. This is what i did.

I downloaded the SQL Server Management Studio Express and run the "shrink" function but the size remains at 14GB. i tried "shrinking" about 4-5 times but no difference in size.

The next thing did was go to Sharepoint 3.0 Central Administration and do a full farm backup from there. Took less than 5 mins to complete.

When i go back to SQL Server Management Studio Express to do the "shrink" i found the log file is already reduced to 145MB. So i did not perform the "shrink" function.

Somehow when i do the backup from Central Admin my config_log file is "shrinked".

Just would like to share. Cheers!
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
Good work!

No luck with the DBCC Shrinkfile command either then?

Author

Commented:
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!

Author

Commented:
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 McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
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?

Author

Commented:
Hi Jamie,

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

Thks
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

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

http://vimeo.com/35720633

Author

Commented:
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.

Author

Commented:
Hope this works!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial