I have a 5 gig database that usually uses about 4 gig for the data and up to 1 gig for the log in SQL 7. I have a backup of a database that I need to reload on a backup system to run some reports off of it since it was from a particular point in time. I set a new database up with size of 4 gig for the data and 1 gig for the log and then load this backup file. The resulting size is 4 gig for the data and 8.5 gig for the log file. sp_spaceall tells me that the log should be no more than 1 gig in size and that I have almost 8 gig free for the db. When I try to shrink the database it leaves it at about 12 gigabytes, but still tells me I have 8 gig free. How can I shrink the size of my log file down (as disk space is a problem on the backup server) to the actual space it uses?