.TRN files will not delete
I am using SQL 2000 and using the database maintenance plan to delete both the .bak and .trn files.
The scheduler deletes the .bak files just fine but NOT the .trn files. The .trn files keep stacking up which I have to manually delete via Windows Explorer.
Any ideas?
The scheduler deletes the .bak files just fine but NOT the .trn files. The .trn files keep stacking up which I have to manually delete via Windows Explorer.
Any ideas?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>Is there a problem in simple databases not having their transactions backed up?
the only functionality you loose is that you cannot restore to a point in time.
with software like you described, the restore process is usually faster by reinstallating the software completely and configuring the few settings and it's gone.
technically, you cannot backup (ie it makes no sense) the transaction log of a database that is in simple recovery mode.
the only functionality you loose is that you cannot restore to a point in time.
with software like you described, the restore process is usually faster by reinstallating the software completely and configuring the few settings and it's gone.
technically, you cannot backup (ie it makes no sense) the transaction log of a database that is in simple recovery mode.
ASKER
It seemed to work. I have one vendor-created database (for spam detection) that is set to simple. Once I took that db off the transaction maintenance, all is well and the .trn files get deleted right on schedule.
Is there a problem in simple databases not having their transactions backed up?