|Title:||What is the best recovery model for SQL Server?|
From a recent email:
What, in your opinion, is the best recovery model for a GP database? Full? Bulk_Logged? Simple? They all seem to have their pros & cons but I can't find anyplace where someone says this model is better than the other two because of X, Y or Z reasons.
Some of the system databases don't support Full, so I usually have two Maintenance Plans - one for the system dbs and one for the user dbs. I never use the 'these specific databases' option because the next time that a database is added to the server, you'll forget to add it to the backup. Choosing the 'all user dababases' option stops that worry.
|Category:||GP TECH INFO: SQL Server|
|Date Added:||June 17, 2010 06:14:34 PM|