In This post we are going to see some various options available for recovery model in SQL SERVER.
From this post you can learn what the available options for recovery model in SQL SERVER
Full, Bulk-logged, Simple
Full : No work is lost, due to failure. It is default recovery model.
Bulk-logged : Allows high-performance bulk copy operations. Minimum space
is required , we can perform recovery when have taken the
backup of the database.
Simple: Allows high-performance bulk copy operations, we can perform
recovery when we have taken the backup,advantage of using this is
minimumspace requirement.
No comments:
Post a Comment