Backing up your database - syncsort_capacity_management - Latest

Syncsort™ Capacity Management Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ Capacity Management
Version
Latest
Language
English
Product name
Syncsort™ Capacity Management
Title
Syncsort™ Capacity Management Guide
Copyright
2024
First publish date
1985
Last edition
2024-08-06
Last publish date
2024-08-06T15:42:28.602035

You or your database administrators will probably have access to the SQL Server Management Studio (SSMS) application. This permits the user to define house­keeping activity for SQL Server, including the backup of a database on a regular basis.

The simplest action is to perform a daily backup of the entire Capacity Database, which will result in a single Windows file being created that could be used to recover the database if necessary.

Another activity that may benefit performance longer term is to perform a “shrink” on the database to remove excess space and reorganize indexes to be more efficient. You can also schedule this from SSMS. A weekly or monthly run of a shrink should keep your database in good working order.

If you use other software you should consult that product’s documentation to help you set up the backup regime you require.