Online Documentation for SQL Manager for SQL server

Setting recovery model and collation


This step of the wizard allows you to set recovery model and collation for the new database.

 

Create Database Wizard - Setting recovery model and collation

 

 

Recovery model

 

SQL Server recovery models are used for backup and restore operations. A recovery model is a database property that controls the basic behavior of backup and restore operations for a database: how transactions are logged, whether the transaction log requires backup, what kinds of restore operations are available, etc.

 

RadioButton Full

When this recovery model is set, all transactions are fully logged and all the transaction log records are retained until after they are backed up. In the Enterprise Edition of SQL Server, the full recovery model allows a database to be recovered to the point of failure, assuming that the tail of the log has been backed up after the failure.

 

RadioButton Bulk-logged

When this recovery model is set, most bulk operations are minimally logged (e.g. index creation and bulk loads), and other transactions are fully logged.

 

RadioButton Simple

When this recovery model is set, most transactions are minimally logged: only the information required to ensure database consistency after a system crash or after restoring a data backup.

 

For detailed information concerning recovery models refer to SQL Server documentation.

 

 

Database collation

Use the drop-down list to specify collation for the database being created. By default, the server collation is used.

 

 

When you are done, click the Run button to view the result SQL statement.