Well...if you lookup your backup schedule you will likely
find that you are doing a full backup periodically (the .bak files) and doing
just transaction log backups (the .trn files) more frequently. You can
easily delete the .trn files that are older than the most recent .bak file...as
well as any .bak file other than the most recent. All of this is of course
as long as you don't need more than one backup. One might argue that you
however shouldn't be storing your backup files on the same hard drive as the DB
anyway for disaster recovery purposes.
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave Barber
Sent: Thursday, May 11, 2006 9:42 AM
To: [email protected]
Subject: SQL server/files question
All,
Our (somewhat old) production server is running a little short on
storage. On the data drive, in the SQL server folder, there are a bunch of
BAK and TRN files.
The bak files are a week+ old, the two largest are 10+ gig. Is it
safe to delete these?
Thanks,
Dave
