Can I delete SQL Server rollback files

Question

I have quite a few "...Rollback Undo...bak" on my SQL Server host going back several years. Can I deleted these files manually?

Answer 1

Hi @OHPRS Admin ,

Welcome to Microsoft Q&A!
"...Rollback Undo...bak" This seems to be your backup file? Do you mean there are a lot of backup files?
Yes, you can manually delete old backup files without affecting the restore database.
But in the long term, I would suggest you create and schedule a maintenance plan in SQL Server Management Studio. You will be able to add a single step (or multiple if you want to automate nightly backups) to clean up back up files after x hours/days/weeks/months.
For the process of automatic deletion I said, you can refer to this article, which contains detailed steps and screenshots.
How to delete old database backup files automatically in SQL Server
If I misunderstood you, please feel free to let me know.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Just to be clear.

SQL Server does not create "...Rollback Undo...bak" files. These must be something an admin created on your server. They are not used by SQL Server.