keeping TRN files

Hello All,
I was wondering if anyone has some 'general rules' on how long they hold on
to TRN files?
thanks...
In a production environment this'll depend on the SLA, if mention is made of
a historical point-in-time recovery and the frequency of tape backups etc.
For my part, I keep all the logs inbetween the last 2 full database backups
and the log directory and database directory are both backed up to tape
which is maintained by a service provider, so in a sense, all logs are held
on to. For the development environment we use simple recovery mode and full
backups only, in agreement with all parties involved that sourcesafe is used
for programming object modifications.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com.
|||I keep them as long as possible. If a backup fails you can restore from the
last successful backup (which could be months ago) and apply all the
transaction logs up to the present. So its a way of backing up your backup -
double protection.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MSUTech" <MSUTech@.discussions.microsoft.com> wrote in message
news:211D0D77-5668-4E0C-A105-64CA2A802D9F@.microsoft.com...
> Hello All,
> I was wondering if anyone has some 'general rules' on how long they hold
> on
> to TRN files?
> thanks...