Share
ReportRan into the SQL 2005 Express limit and resolved by updating to SQL 2008 R2 Express.
However, we did try to shrink first after removing data and I found something I haven't seen before. When running script to sort tables by size, and then checking the size of the RMS tables, total size off all RMs tables was 2.55GB. The other 1.75 GB in the database was taken up by NULL.
Googling revealed that this is essentially a SQL Heap table, if what I found is correct. but I couldn't find any way to address the size of this table, or figure out why it is there. I have not seen this in any prior episodes of full databases. The NULL table is still there and holding onto 1.75GB. :-(
Anyone have any thoughts or solutions for this?
Regards and thanks,
Heidi
*This post is locked for comments
All responses (
Answers (
291,280
