Correct.. One full backup means you can remove all the transaction files/logs .... assuming it is a good backup of course...
Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of M Jarvis Sent: 11 April 2012 19:13 To: [email protected] Subject: [NF] Question about MS SQL Server backups I'm a bit rusty... working on doing a backup and cleaning up some disk space. If I have a backup of the DB and the Transaction log from 2/14/2011, and I just did a DB and Transaction log back today, since I have the new DB and TRN I can safely delete the 2/14/2011 version? i.e. I'm covered since I have the latest greatest snapshot of the DB and TRN files? This server is swimming in TRN files and I just want to make sure I have one good snapshot.... -- Matt Jarvis Eugene, Oregon USA [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
