Hi
What commands are you using to shrink it?
If you aren't sure of the commands, you can do it this way:
1) Go into SQL Enterprise Manager
2) Browse to the name of the DB under the Databases section
3) Right click the DB, go to all tasks, then 'backup database'. Select a transaction log backup, and back it up. Doesn't matter where if your only intention is to shrink the file; backing it up allows the system to mark the log as used so it can be removed.
4) Exit the backup dialog, and then right click the DB again... click All Tasks, then Shrink Database. Click the 'Files' button, then select the 'log' file in the Database file drop down menu. Hit OK.
Regards
Aaron
Aaron
Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
