Should we backup the tablespaces created for SQL Server
Hi folks
I had to install the CLM using the MS SQL Server.
During the jts/setup, when we configure the Data Warehouse, we are asked to designate a Database Table Space Folder.
The setup creates 5 files:
- VNF_32K.ndf
- VNF_IDX.ndf
- VSTR_32K.ndf
- VSTR_32K2.ndf
- VSTR_IDX.ndf
I was wondering if we need to backup these files when we backup our DB?
Thanks for your help
I had to install the CLM using the MS SQL Server.
During the jts/setup, when we configure the Data Warehouse, we are asked to designate a Database Table Space Folder.
The setup creates 5 files:
- VNF_32K.ndf
- VNF_IDX.ndf
- VSTR_32K.ndf
- VSTR_32K2.ndf
- VSTR_IDX.ndf
I was wondering if we need to backup these files when we backup our DB?
Thanks for your help
Accepted answer
You should.
In case a data warehouse such as Rational Reporting for Development Intelligence or Rational Insight is set up, keep in mind that setting up a separate backup procedure for its database and configuration data is also needed.
It is necessary to backup all databases used by the applications. The RM application since version 5.0 has its own database. In versions before 5.0 RM used the JTS database to store its data and therefore did not have a separate database to back up. If you use a data warehouse, also set up a backup procedure for its database.https://jazz.net/wiki/bin/view/Deployment/BackupCLM