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.
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.
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.
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.
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.
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.