Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: shrinking log file

    hi all

    greetings and very sorry for cross posting. Having sql server 2005 standard with processor license. Migrated a database from 7.5 and retained backward compatibility settings, since the front end software cannot be changed.

    Unable to shrink log file since the database is not recognized in maintenance plan. DBCC SHRINKFILE is not giving the desired result. The logical size is only 289 mb but the physical size is more than 2 GB.

    Please help

    Thanks and Regards
    K. Sankara Raman

  2. #2
    Join Date
    Dec 2007
    London, UK
    What recovery model are you using? Have you backed up the log?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts