cannot change LOG file size

Posted on 2014-08-04
Last Modified: 2014-08-04
Hi Experts,

I have a SQL Server 2008 with some DB´s.
I want to change the LOG FILE size from 37 GB to 24 GB.
But this is not working.
Maybe it is a problem with the disk, because the Disk of the LOG FILES is full.
Can you give me  a hint to solve it ?
Question by:Eprs_Admin
    LVL 14

    Accepted Solution

    the log file can be shrinked by

    USE yourDB;
    LVL 7

    Expert Comment

    by:Pushpakumara Mahagamage
    Backup logfile, and then shrink

    Backup Log yourDB TO Disk = 'D:\temp\myfileasa.bak'

     -- DBCC SHRINKFILE ( yourdb_log, 24GB )
    LVL 7

    Assisted Solution

    by:Pushpakumara Mahagamage

    Author Comment

    after the LOG backup it worked. Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now