That is incredibly true; I heard a few days ago that a test restore had been tried on our big ERP application (first time ever), only to find that it didn't work (the backup was performed on data that was being updated).
I don't think we've ever had to do a restore of the database, not even sure there is a DR plan in place either.
Thanks,
Dave
On 11/05/06, L. J. Head <[EMAIL PROTECTED]> wrote:
**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**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.RegardsDave
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___
__20060125_______________________This posting was submitted with HTML in it___
