Disk space full after deleting the records

  • How to delete data from table when disk space is low so that it doesn't logs the transaction?

  • Are you trying to delete all records on a table? If so, truncate table has low overhead with respect to logging. You can delete in small rowsets and backup the log often. You can also set the recovery mode to simple and then issue the delete, again low overhead. Once done, reset to full recovery mode and take a full backup of the database. Lastly, buy more disk, especially if this is a production database!

    -- You can't be late until you show up.

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

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