Post reply

disk space used fully

  • January 12, 2015 at 7:54 am

    #293639

    for the sql server we had only one drive of capacity 890GB and the free space is 250GB.

    All the file are in C: drive only.we got a ticket that the disk space free space is zero for c drive.After 2 hours the space is released automatically and they said now the free space is 250 GB.

    I have checked the maintaince jobs like dbcc checkdb,shrinkdb,backup,reorganise runs every day.only rebuild runs sunday.Here the temp db log or mdf is set to unrestricted size.All the databases are simple recovery model even the user databases also.The issue came twice .please help me what to do.I did some changes in the maintence jobs like setting the jobs alternate days.

  • January 12, 2015 at 8:18 am

    #1769524

    Simple Recovery? Are you taking any backups?

    Also, is the C: Drive on a SAN or is it on a disk in the server itself?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 12, 2015 at 9:25 am

    #1769546

    Thanks for your reply we are using simple recovery only.we are taking full backups everyday(tape).Drive it is on harddisk

  • January 12, 2015 at 9:26 am

    #1769547

    if using maintenance plans the backup may be filling the drive and then the space is being released when the maintenance plan deletes the oldest backup.

    You would be advised to spread your databases and backups out across seperate drives.

    ---------------------------------------------------------------------

  • January 12, 2015 at 10:11 am

    #1769568

    backups are taken directly into tape drive every day.

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

You must be logged in to reply to this topic. Login to reply