Sharewebdb_log is 22GB.

sharewebdb has been reduced down to 514Mb through use of the fix me tool.
sharewebdb_log has since grown to be 22GB which is a quarter of the whole drive so I want that space back.
I've connected to the DB using SQL Express, backed it up then shrink the DB, but only reduced by 0.5GB not the savings I hoped for.
Joined Expert Exchange for the solution, fingers crossed you guys can help. SBS Disk Usage
CiaranMageeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

martushaProduct managerCommented:
You have to backup transaction log - then shink -> files -> choose transaction log file to shrink.
0
CiaranMageeAuthor Commented:
Thanks for the feedback. I forgot to say I have backed it up correctly from with SQL Express before attempting to shrink.
Should I reboot the server after backup or any services before attempting shrink as this has not done much for me so far.
If so I'll need to schedule a restart.
0
martushaProduct managerCommented:
You have 3 option for backup: full backup, differencial backup and transaction log backup (if your database operational mode is Full).
You should do transaction log backup. Then backup done - choose to shrink not database, but Files and select "Log" in the dropdown.
Sometimes you should do it 2 times (backup, shrink, backup, shrink).

If this doesnot help you, another option is to change the database operational mode to "Simple", then shrink transaction log - > and change operational mode back.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.