CE10 - How do I back up the folder structure and its reports? 2

[SCantoria]

Is there a way to backup the folder structure I have created and all the reports in it in CE10?


Thanks,

Steve C.

 

[Turkbear]

Hi,
The folder structure you see in the CMC does not 'really' exist..It is produced by code in the CMS database - so backing up the database effectively backs up the folders.

The published reports themselves are stored on your Input and Output directory locations and these can be backed up using any file system backup program..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Yes, and you also want to back up the database used to keep track of them or they are pretty much worthless because they have a GUID type of naming convention to the structure and the files.

This handles all of the reports and their instances:

C:\Program Files\Business Objects\BusinessObjects Enterprise 11\FileStore

(your path may vary, check your input and output servers using the CMC to learn your exact locations).

The SQL Server MSDE database is probably found here (if you used the default database):

C:\Program Files (x86)\Business Objects\MSSQL\DATA

C:\Program Files (x86)\Business Objects\MSSQL\LOG

-k

 

[synapsevampire]

My apologies, I gave you the database path for BO XI, look for SQL Server or some such on the CE server, can't recall the path in CE 10.

 

[JeroenBoon]

But,

where are all the schedule information, groupnames, rights etc stored? When I backup only the input and output file, do I also backup al the other info CE needs?

Jeroen.

 

[Turkbear]

Hi,
All the other info is in the CMS database tables..

So, back up the FileStore locations and your CMS database.

If this is done you can always recreate your current system from those backups ( will be a 'point-in-time' backup as of the latest backup date/time - be sure to synchronize the database backup with the FileStore one, so that the contents of the file locations will match the database entries.. - that is, do them when no new objects are being created/modified)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

<nodding>

The key is to get the database, trust me, I had an administrator state that they were backing up the database, but they weren't (the issue is that the SQL Server file is in use so a conventional backup tool might skip it).

-k

 

[baycolor]

So if I...
Backup the files mentioned.
Uninstall CRES XI.
Reinstall CRES XI.
Restore the files mentioned.
I will have in the reinstalled CRES instance all of my reports, scheduling setings, parameter settings, user info, user permissions, etc?

My apologies if I should have started a new thread.

 

[Turkbear]

Hi,
Yes, as long as you specify the same FileStore locations ( and they have been restored to that location, or never removed) and the same database connection info.





To Paraphrase:"The Help you get is proportional to the Help you give.."