February 22, 2008 at 2:57 pm
What features of SQL Server require you to use full logging?
February 23, 2008 at 12:56 am
tigersam_20002000 (2/22/2008)
What features of SQL Server require you to use full logging?
The database in question needs to be in FULL recovery mode.
Make sure you take frequent transaction-log backups when that's the case (say every 10 min) because otherwise your log file will grow indefinitely - there will be no truncation of the portion containing committed transactions.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 23, 2008 at 9:32 pm
tigersam_20002000 (2/22/2008)
What features of SQL Server require you to use full logging?
Whether or not you use simple or full recovery model is not dependent upon any features of SQL Server. This is a decision you need to make based upon the business requirements for the database in question.
If your system can sustain a loss of up to a day's worth of data, then simple recovery model is fine. If not, then how much data can you lose? Four hours? One Hour? 15 Minutes?
Once you understand the business requirements, you then set the recovery model and build your maintenance plan.
The tasks you define in your maintenance plan(s) will be dependent upon the backup window that you have, how large your database(s) are and the activities of the system.
HTH,
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 24, 2008 at 2:20 am
Log shipping also requires full recovery mode, and im pretty sure mirroring does as well.
Point in time restore requires full recovery model.
Thats all i can think of right now, there are probably a few more tho.
February 27, 2008 at 10:10 am
log shipping, database mirroring, point in time restoration, replication they need to be in full logging mode.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply