gosh. If you have data in a database, it must be important. One of the chief requests for help on this and other forums is to recover the contents of a table that someone accidently truncated, deleted, or dropped and the poster doesn't have backups Unless the database is an archive database that's only update once per month or a "staging" database where the data is only transient at best, I'd make sure that the database was set to the FULL Recovery Model and I'd setup Point-in-Time log backups to occur at least once an hour (10 to 15 minutes is my normal setup, though).