Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Recovery Models in SQL server

    @vishwanath.rana
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 184
    Comment on it


    There are three types of Recovery model in SQL server

    Simple recovery model -- gives you the backup to replace the entire database in the event of a failure . In simple recovery model data is recoverable only to the most recent backup . User can user this recovery model when data is static .SQL server in this model maintain very less amount of information in the transaction log because each time databse reaches transaction check point ,SQL Server automatically truncates the transaction log .

    Bulk-logged recovery model -- This type of recovery model can be used while performing bulk importing of data or while doing large scale operation .Bulk-logged model minimise the log space usage while using minimal logging .

    Full recovery model -- The full recovery model guarantees the least risk of losing your work if a data file gets damaged .In this model SQL server fully logs all operations . In this model you can recover to any point in time .

    Recovery Models Recovery Models in SQL server SQL Server Bulk-logged recovery model Full recovery model Simple recovery model
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: