Viewing 4 posts - 1 through 4 (of 4 total)
Thank you for sharing EXEC sp_spaceused. It showed me where my data is, 130GB is in index alone. I double checked all my index and a lot have AVG_FRAGMENTATION_IN_PERCENT greater...
November 20, 2011 at 5:11 pm
Sorry, I think I should paint the story clearer.
I just inherited this SQL Database Server that has not never been actually maintained ever since it was upgraded to SQL 2005....
November 20, 2011 at 3:57 am
What I actually plan to do on a weekly basis is to do 1 full backup on the Sunday's. And then, on twice a day, do a transaction backup.
November 20, 2011 at 2:47 am
Thank you for your quick response.
I need to release free space to the OS or free up space in simple terms because I am loosing disk space. This server has...
November 20, 2011 at 2:40 am
Viewing 4 posts - 1 through 4 (of 4 total)