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.