SQL Database Server Maintenance
-
SQL Database Server Maintenance Overview
To maintain a healthy and well-performing environment, the database server should run a number of scheduled maintenance jobs. Some jobs are included during i...
-
Restoring and Deleting Databases
Restoring Survey DatabasesIf a Forsta Plus database is restored from backup, service broker must be set manually for the database so that Forsta Plus will fu...
-
Automatic Detachment of Inactive Databases
Automatic Detachment of Inactive Survey DatabasesThe traditional Forsta Plus database model operates with a separate database for each survey created on a si...
-
Index and Statistics Maintenance
Although SQL Server seems to become better at managing statistics as the years go by, we highly recommend setting up agent jobs to update statistics at least...
-
Shrinking Databases
In most cases we do not recommend shrinking databases as this often just leads to more autogrow events and reduced performance when the database has to grow...
-
Cleanup
Design Log CleanupThis task does not have any parameters, but uses the DesignerLogCleanupPeriod setting in System Configuration. This is set by default to 18...