I've got a log file that's over 27gb with a datafile that's about 600mb.
After doing data and log backups, I (reluctantly) did a DBCC shrinkfile on the log via Enterprise Manager, and it tells me that the file is now about 135mb. But, the actual physical file is still over 27mb. Enterprise Manager tells me that the file is 94% free (makes sense), but how can I reduce the actual file size on disk? THAT's my primary problem.
My client never too a backup of this database or log, if you can believe that!!!
After doing data and log backups, I (reluctantly) did a DBCC shrinkfile on the log via Enterprise Manager, and it tells me that the file is now about 135mb. But, the actual physical file is still over 27mb. Enterprise Manager tells me that the file is 94% free (makes sense), but how can I reduce the actual file size on disk? THAT's my primary problem.
My client never too a backup of this database or log, if you can believe that!!!