Page History
...
Be aware that the index and the table are unavailable during the rebuild.
Backing up the database and creating archiving
Use the Database Maintenance Plan function to create a backup plan for the database. Make sure that the SqlServer agent is automatically started at database startup.
- If you choose the simple recovery mode for the database (the transaction log can be deleted after a commit or checkpoint) , the recovery does not work to a point in time, but only to the backup time.
- If you choose a full recovery mode for the database, make sure you also backup the transaction log and shrink the database periodically , to stop the transaction log from growing infinitely.
| Warning |
|---|
If you do not create a backup, information is lost when you have a database crash and you cannot recover data . |
Additional DBA settings
To improve performance, the DBA on site must check that the settings in the following table contain the correct values.
Table 1 Additional DBA settings
| Setting | Description | Value |
|---|---|---|
| Size of the datafile | The default size when you create the PMDB. | 2GB |
| Size of the log file | The default size when you create the PMDB. | 500MB |
| Auto extent size for datafiles and logs | The size of the new segment to be allocated. | 30% of the initial datafile For example, if the datafile is initially 1GB, the auto extent size should be 300MB. If you have a very large installation, the auto extent size should be 1GB. |
| Tempdb location | Put the tempdb database on a fast I/O system. |