Home Forums SQL Server 2005 Administering How space is allocated for new objects in the data files? RE: How space is allocated for new objects in the data files?

  • My local drive (H drive) is full.

    Could you identify what are making the drive full?

    Is it becuase of your DATA files? or Your Transactional Log file (.LDF) is too big?

    Do you have transactional log backup regularly?

    If it is due to the big log file AND no T-log backup regularly, you may choose to truncate the Log file:

    BACKUP LOG DBNAME WITH NO_LOG

    After this, do a fullbackup; then set up transactional log backup job to run regularly to prevent the wild log file growing.