Progress Update - 24-Sep-13

Meeting     Progress Update   24-Sep-13 Attendees: Lorna, Julia, Stuart, Gilian, Anne

Agenda

1              Issues with Live Deployment

2              Questions

3              Plan

4              AOB

Hi Quentin - 23-Sep-13,

 Port 8732 has been opened but not for my machine. I've tried this locally on the browser on the application server and it just sits at a blue screen saying "Loading...". I'm assuming this should load a login screen if the Workflow was working correctly?

 I've applied the new licence and I'm able to launch the Control Centre. Is this enough verification that licence is applied successfully and has the relevant settings or is there some way to test this? Screenshot of licence Overview from CP Control Centre is attached.

 1)I will await your feedback on the permissions required for the corplan user. From a security perspective we would feel more comfortable with the previous permissions of "dbcreator" and "bulkadmin" and "public" and I believe this would provide the privileges required to create, restore, delete databases from the server. I would be interested to know what additional commands require the sysadmin level of access.

 2) It is not obvious to me how to create a backup from the "manage backups tab" so I think this is something that will need to wait for one of the users to test. There is a "Create Server-Side Backup..." in the create backups tab but as I only have access to the root username I'm not sure if this user has the relevant permissions to carry out this task or if we should be doing this as this user. The corplsql and corpladm usere both have access to read and write in this directory.

 3) I've stopped Reporting Services and disabled this from Automatic startup. If we do implement the CP Cons product at a later date we will need to be involved in the configuration of this to ensure we have a backup of the symmetric key for disaster recovery pruposes.

 4) We will need to ensure that the requirements for the users to have data recovered is met by the backup policy we put in place. I will get Anne to follow this up with Lorna. If we only take a nightly backup and this backup failed we would have to go to a previous backup we would therefore recommend taking taransaction log backups to allow us to roll forward. The transaction log backups will only run for databases in full recovery model which is only the CPSERVER_REPOSITORY, cpworkflow, ReportServer databases. All other database which are running in simple recovery model will not run transaction log backups.

 We did notice that some of the database have "Auto Close Enabled" set to true. We would recommend this is set to False as the transaction log full of checks which will impact the performance of the server. The model database has this set to false so I'm wondering if this is a setting that has been automatically as migrated with some of SQL Express databases. All the UoEd_TRAC database have correct setting of false as do the main CP database but the PRAM databases and a few others have this set to true.

Can we switch "Auto Close Enabled" to false for all databases?

 Thanks, Gillian