HardCode
10-15-2004, 08:25 AM
I have a log file for my development DB on my SQL Server. This log file is 2GB large. In Enterprise Manager, I:
Right-click the DB
Select Backup Database
Run a backup of both DB and Log Files
Right-click the DB
Select Shrink Database (3549MD allocated, 2637 Space Free)
Select 10% for Maximum free space in file after shrinking
Click OK
Get MsgBox saying Shrink is done.
When I check the size of the log file in MyComputer, the log file is still 2GB when the DB is only 1.5GB. So then I:
Right-click the DB
Select Shrink Database
Click Files... command button
Select the log file name in the dropdown box
It shows Current Size: 2014MB, Space Used 20MB
Try Compress pages ... option, file still 2GB
Try Truncate free space... option, file still 2GB
Shrink file to: and set it to 50MB ...file still 2GB
No matter what I do, the log file remains at 2GB. What the heck is going on? If Enterprise manager says the file uses merely 20MB, why won't the file shrink any less than 2GB???
Right-click the DB
Select Backup Database
Run a backup of both DB and Log Files
Right-click the DB
Select Shrink Database (3549MD allocated, 2637 Space Free)
Select 10% for Maximum free space in file after shrinking
Click OK
Get MsgBox saying Shrink is done.
When I check the size of the log file in MyComputer, the log file is still 2GB when the DB is only 1.5GB. So then I:
Right-click the DB
Select Shrink Database
Click Files... command button
Select the log file name in the dropdown box
It shows Current Size: 2014MB, Space Used 20MB
Try Compress pages ... option, file still 2GB
Try Truncate free space... option, file still 2GB
Shrink file to: and set it to 50MB ...file still 2GB
No matter what I do, the log file remains at 2GB. What the heck is going on? If Enterprise manager says the file uses merely 20MB, why won't the file shrink any less than 2GB???