• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2393
  • Last Modified:

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
  • 2
1 Solution
martushaProduct managerCommented:
You have to backup transaction log - then shink -> files -> choose transaction log file to shrink.
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.
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.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now