MS SQL Server New Users - SQL Maintenance plan

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Maintenance plan

DavidE

2005-04-26, 9:23 am

I have a maintenance plan to backup my database and the T-Logs. When I go to
the directory were I set these to be backed up to I have the DB backups but
there are no .TRN files for my t-logs. any idea why my maintenance plan
wouldn't backup my t-logs

Keith Kratochvil

2005-04-26, 9:23 am

Is the database set to simple recovery mode?

--
Keith

"DavidE" <DavidE@discussions.microsoft.com> wrote in message
news:8F03E12F-0203-4132-99CD- C77C43677913@microso
ft.com...
>I have a maintenance plan to backup my database and the T-Logs. When I go
>to
> the directory were I set these to be backed up to I have the DB backups
> but
> there are no .TRN files for my t-logs. any idea why my maintenance plan
> wouldn't backup my t-logs

Sponsored Links