I have a SQL Server 6.5 DB that is allocated 1200 MB for data and 1000 MB for the log. It was showing 500 MB free for data and 40 MB free for the log. I needed to import new data (to synch with a dos system for paralell testing). I made a backup of the entire DB. Then I deleted 90% of the data (a few tables data did not change and these tables are not dependent on any other table being there), truncated the transaction log, and recalculated. Now with no data and a transaction log i just truncated i show 0.00 MB of log space and 20.62 MB of data space when i recalculate. What's going on? How do i completely clear out the transaction log? How did i go from 4,000,000 records worth of tables taking up 700 MB to less than 500 records in the entire DB taking up over 1.1 GB? foxdev, TomSark, I would appreciate a short explanation of backup procedures and clearing out logs if you have the time. Thanks in advance. Ruairi
Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.
Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.