January 13, 2006 at 5:57 am
hi,
can anyone help me about the database recovery model??
Full??? Simple??? bulked_log???
which one is better where the sizo of database is very huge.
Thanx.
January 13, 2006 at 9:23 am
The size of the database doesn't matter so much as your organization's tolerance for data loss i.e. how much data would you be willing to lose if you had to recover from a backup?
Simple - you can recover to the end of a full database backup
Full - you can recover to a point in time with the use of full, differential, & log
backups
Bulk-Logged - you can recover to the end of
See 'Selecting a Recovery Model' in BooksonLine. It has, IMO, a good comparison of the 3 recovery models.
Greg
Greg
January 13, 2006 at 11:46 am
Thanx Greg!!
I got it in BOL, and found very usefull information and exactly that i want.
Thanx again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply