It’s not an option; you need the transaction log to recover to the point
of time.
Either you edit the current maintenance plane or create new one that
includes the transaction log


> Yes it is an "option" to allow data loss.....
>
> If you need point-in-time recovery, you need TLOG backups.
>
> Dano
>
> -----Original Message-----
> From: Mangual Janet A. (WASD)
> [mailto:mssqldba-ezmlmshield-x7914357.[Email address protected]
> Sent: Tuesday, November 30, 2004 3:12 PM
> To: LazyDBA Discussion
> Subject: Backup Recommendations [faked-from]
> Importance: Low
>
> Hello experts!
>
> WE have a third party application+database installed by Consultants.
> They
> have a maintenance plan that performed a full backup weekly and an
> incremental every day. They do not create a backup for the transactions
> logs. My understanding if we need to go back in time whenever performing
> a
> recovery, we need to also have the transaction logs. The consultants'
> argument in that it is optional. Any advice will be appreciated. Thanks.
>
>
> Janet Mangual
> Database Administrator, MIS Division
> Miami-Dade Water & Sewer Department
> e-mail: [Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>


Fahed Ibraham Yoseph
Senior DBA and System Analysis
MCDBA
OCP
965 665-6210


MS Sql Server LazyDBA home page