Q: TRN backup files

Hello,
In my backup maintenance, I have set deletion of backup files after 3 days,
it works for complete backup but not for transaction backup. (I see *.BAK are
removed, *.TRN are still there) what is problem?
Thanks,
Jim.Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> Hello,
> In my backup maintenance, I have set deletion of backup files after 3 days,
> it works for complete backup but not for transaction backup. (I see *.BAK are
> removed, *.TRN are still there) what is problem?
> Thanks,
> Jim.
>|||where can I check if it is in recovery mode?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||yes you were right, the database is in full mode, other databases are in
simple mode, what is difference? If simple mode, is it not recoverable? I do
not see any TRN files if the database is in simple mode, is this a problem?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||mmm. I was reading it, I guess I need to keep it in full mode, but how far
does this TRN file go, is there a limit, or can we create a limit?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||This is a too big topic for a newsgroup conversation. I suggest you read in Books Online about how
backup and restore work in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:2734BEE1-0312-45BE-B1F2-5EEFD6450A69@.microsoft.com...
> yes you were right, the database is in full mode, other databases are in
> simple mode, what is difference? If simple mode, is it not recoverable? I do
> not see any TRN files if the database is in simple mode, is this a problem?
> "Tibor Karaszi" wrote:
>> Perhaps the plan involves trying to do log backup for databases which are in simple recovery
>> mode?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
>> > Hello,
>> > In my backup maintenance, I have set deletion of backup files after 3 days,
>> > it works for complete backup but not for transaction backup. (I see *.BAK are
>> > removed, *.TRN are still there) what is problem?
>> > Thanks,
>> > Jim.
>> >
>>