Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: DBCC SHRINKDATABASE TRUNCATEONLY

    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...

  • RE: DBCC SHRINKDATABASE TRUNCATEONLY

    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....

  • RE: DBCC SHRINKDATABASE TRUNCATEONLY

    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.

  • RE: DBCC SHRINKDATABASE TRUNCATEONLY

    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...

Viewing 4 posts - 1 through 4 (of 4 total)