June 11, 2002 at 11:06 am
Hello everyone, I have a few questions.
I have a log file that is 12,908 Megs. I performed the following:
Right click on the database, choose all tasks->shrink database->files->compress pages and then truncate free space from the file
After the shrinking of the log file, on the Shrink file page (same page used above to shrink), I have the following:
Current Size: 8822.00 MB
Space Used: 8822.00 MB
However, when I go to the directory where the log file is, it shows that the file is still 12,908 Megs. Also, when I right click on the database in Enterprise Manager, and go to Properties, under the Transaction Log I see that the space allocated is 12,908 Megs. Can someone tell me what is going on and how do I shrink the file to the 8822 Megs?
Thank you in advance!
June 11, 2002 at 3:06 pm
This problem comes from the vitual logs inside the transaction log not freeing. Look here for a script to help force the file back down. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 18, 2002 at 11:30 am
Hi, do I run this scripts before or after a full backup?
June 18, 2002 at 3:27 pm
I would do a Transaction log or a full to file backup then run the script then the full backup.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply