The only server I normally have direct access to is the test system, and to be honenst, I've rarely looked into SQL server in much depth, so I wasn't too sure how safe it was to delete those files.
Thanks for the info - with there being 2 .bak files, being about 10 or 11 gig each, that means that both are full system backups, I'll delete the older one.
Regards
Dave
On 11/05/06, L. J. Head <[EMAIL PROTECTED]> wrote:
**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__20060125_______________________This posting was submitted with HTML in it_____20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
