Hi Sachin
Normally we don't take daily backup of Report Manager DB. The actual
recommended procedure as per CA is:
*1.Select Control Panel, Administrative Tools, Services, Spectrum Tomcat,
and then click Stop in the Spectrum Tomcat Properties box to stop Tomcat.*
*2.Select Control Panel > Administrative Tools > Services > SPECTRUM MYSQL
Database Server, and then click Stop in the SPECTRUM MYSQL Database Server
Properties box to stop the SPECTRUM MYSQL database server.*
*3.Go to the <$SPECROOT>/mysql/data directory.*
*4.Save backup copies of the following databases to a secure directory
outside of the <$SPECROOT> installation area:*
*..reporting*
*..archive*
*5.Restart Tomcat and SPECTRUM MYSQL Database Server.*
**
As you have spectrum 8.1 in Suzlon, you can use the below procedure:
This process can also be used for SPECTRUM 8.1.0, however in 8.1.0 we offer
a backup feature in SRM.
1. Go to the Admin Tools tab of SRM
2. Click on "Database Management"
3. Click on "Backup Landscape"
4. Select the landscape you wish to backup and hit "Start"
5. This will go through the tables and create backups of them. The
process is complete when the message "Operation is complete" is displayed.
Although if you can get above steps (first one) scripted in a file and
schedule it weekly in windows scheduler. You can also try the steps
suggested using mysqldump utility.
Regards:
Gaurav Partap
Behind an able man, there are always other able men……………….(GAURAV PARTAP)
On Thu, Oct 29, 2009 at 12:21 AM, <[email protected]> wrote:
> I think Sachin is asking for SRM-DB not SSDB or DDMDB.
>
> I am not aware of Scheduling in SRM-DB but users can Backup from Admin
> Tools --> Database Maintenance --> Backup Landscape. Other options available
> are Restore and Manage.
>
> It would be nice to know if scheduling can be done for SRM-DB, or perhaps a
> hack :-)
>
> Thank you - Ali
>
> ------------------------------
> *From:* Gaurav Partap [mailto:[email protected]]
> *Sent:* Wednesday, October 28, 2009 1:29 PM
> *To:* spectrum
> *Subject:* Re: [spectrum] Schedule Backup Of Report Manager
>
> Hi Sachin
>
> There are many options for database scheduling. First decide what kind of
> backup you want. There are two options:
>
> 1. Online Backup
> 2. Offline Backup
>
> There can be only SSdb backup. DDMdb backup or you can associate DDMdb
> backup with SSdb backup. It can be scheduled using the Spectrum Control
> panel. There are two command line utilities like SSDbsave/SSdbload and
> DDMdb_save/DDMdb_load/backup. If you want to associate DDMdb backup with
> SSdb backup, there is one script where you just need to uncomment one line.
> If you want backup using command line utilities, you have options of backing
> up full database, models only or catalogues only. In suzlon setup better use
> command line utility with DDMdb backup associated with SSdb backup. Use
> windows scheduler and take a models only backup daily and full backup
> weekly. Let me know if you have any queries.
>
> Regards:
> Gaurav Partap
>
> Behind an able man, there are always other able men……………….(GAURAV PARTAP)
>
>
>
>
> On Fri, Oct 23, 2009 at 3:30 PM, CATools Helpdesk <
> [email protected]> wrote:
>
>> Hi,
>>
>> How to schedule the backup of report manager in Spectrum.
>>
>>
>>
>> Thanks in advance.
>>
>>
>>
>> *Thanks & Regards, *
>>
>> *Sachin Bhor*
>>
>>
>>
>> --Disclaimer-- This email and any files transmitted with it are
>> confidential and intended solely for the use of the entity to which they are
>> addressed. If you have received this email in error please notify the sender
>> immediately. Please note that any views presented in the email are solely
>> those of the author and do not necessarily represent those of the
>> organization. While all care has been taken to avoid viruses the recipient
>> is advised to check this email and attachments for presence of viruses. The
>> organization accepts no liability on this account. Mails may be stored for
>> monitoring and review.
>>
>> - --To unsubscribe from spectrum, send email to [email protected] with
>> the body: unsubscribe spectrum [email protected]
>>
>>
>
> - --To unsubscribe from spectrum, send email to [email protected] with
> the body: unsubscribe spectrum [email protected]
>
>
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]
