Home Forums SQL Server 2005 Administering Shrinking a Transaction Log file (BMC Remedy environment) RE: Shrinking a Transaction Log file (BMC Remedy environment)

  • [font="Arial"]

    Yes Gail, i've thought something similar .. In any cases i've preferred to execute a new query defining the old path for the ldf file. I will attempt again next week, and i will open for this activity a new change.

    In any cases now seems that DB is running again end the Log file has been restricted to 3,7 GB. The disk has now 75% of available space.

    I feel that a good thing i should do can be to perform a Log Bckup more frequently ... Now i have scheduled it daily, at 7 AM, while the DB backup start once a week at Sunday at 4 AM.

    The system is a Trouble Ticketing system so i feel that making a Log backup every hour should be enough, leaving the Complete backup once a week.

    For the moment i thank you very much for all the suggestion you gave me. I am not a DBA so i prefer to move my steps in this field with caution ... Maybe asking to someone that can give some help.

    Thanks again, Gail. I will let you know about my progresses.

    Ciao from Italy

    [/font]

    Alessandro Feltrin
    Information Security Professional
    CISA Certified
    ITIL v.3 Foundation Certified
    BooleServer 3.2 Certified