SCENARIO 1:
When the Instance Configuration is run to create Activity Logging (either during installation or separately), why are LiteSpeedLocal and Central created in Full Recovery mode and not Simple?
SCENARIO 2:
By default, the Litespeed repositories (LiteSpeedLocal & LiteSpeedCentral) are set to "Full" recovery model. Is this required or can it be changed to "Simple"?
The create database process that is run during Instance Configuration uses a copy of themodeldatabase to initialize the database and its meta data (similar to native SQL Server) however; Prior to v6.5, repositories were always created with the default you have defined on SQL Server. If your model database was set to Full, then new databases are created with that recovery model. Starting in 6.5 we created new LiteSpeed repositories in Simple if LiteSpeed creates the database. If you have a db that you want to change, you simply do this from Management Studio like any other database.
For additional info, see:http://msdn2.microsoft.com/en-us/library/aa258257(SQL.80).aspx
Also see Books Online for explanation of Recovery Models: The simple recovery model does not support log backups. Backup is easy to manage because the transaction log is never backed up. However, if there are no log backups, a database can be restored only to the end of the most recent backup of the data. If a failure were to occur, updates that are made after the most recent backup of the data are lost.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center