October 31, 2008 at 1:25 pm
If you perform only daily, full database backups, is there any reason to keep a database using the FULL recovery model? Or is the FULL recovery model only useful if you back up the transaction log on a consistent basis?
October 31, 2008 at 1:32 pm
if you recovery methods only include a nightly full backup then unless the database is being used for log shipping, mirroring, etc I don't see a reason why you couldn't/shouldn't switch it to SIMPLE recovery mode.
October 31, 2008 at 2:05 pm
See today's headline article. (http://qa.sqlservercentral.com/articles/64582/)
What's acceptable data loss for that system? A full day?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 4:25 pm
GilaMonster (10/31/2008)
See today's headline article. (http://qa.sqlservercentral.com/articles/64582/)What's acceptable data loss for that system? A full day?
Yes, I can lose up to a day for the databases in question. Some other DBA (no longer with the company) set the recovery model to full. However, they only performed full backups and never any transaction backups.
November 1, 2008 at 2:33 am
Then set the DB to simple. No point in full if there are no tran log backups
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply