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]


MS Sql Server LazyDBA home page