The only advise I'll give you regarding backups is what was
given to me..."A backup is only as good as the last time it was restored"...and
with both files being in existence...I would be willing to bet that if you
delete it today...it will be re-created within a week. I think your best
option is to change your Maintenance schedule in SQL Enterprise Manager to
either not keep the history that it currently keeps...or to move the backup
location to another place
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave Barber
Sent: Thursday, May 11, 2006 11:53 AM
To: [email protected]
Subject: Re: SQL server/files question
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___ __20060125_______________________This posting was submitted with HTML in it___
