Hi Can be done using an application Spectrum has in its bin directory see below for an example I use on Windows servers, same thing works on Nix platforms
cd e:\win32app\spectrum\bin backupreportingDBlandscape.bat <user> <pwd> <servername> and user and password in this case is the default mysql user - root pwd root On 10/29/09, [email protected] <[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]<mailto:[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]<mailto:[email protected]> with the body: unsubscribe > spectrum [email protected]<mailto:[email protected]> > > > * --To unsubscribe from spectrum, send email to > [email protected]<mailto:[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]
