DeRay_Scholz
Active Member
This is to all the SQL Server gurus out there.
We have a database (Sql Server 7.0) that is taking up 11 gigs of free space with the transaction log. I have truncated the log, set the option to truncate log on checkpoint, ran a sql server backup of the database, stopped and restarted sql server.
The log has shrunk to 36 MB of used space but still has 11 gigs of free space. What do I need to do to free up this space?
Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.2 NT / SQL Server 7.0
We have a database (Sql Server 7.0) that is taking up 11 gigs of free space with the transaction log. I have truncated the log, set the option to truncate log on checkpoint, ran a sql server backup of the database, stopped and restarted sql server.
The log has shrunk to 36 MB of used space but still has 11 gigs of free space. What do I need to do to free up this space?
Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.2 NT / SQL Server 7.0