April 02, 2014

Sanchay Post To be performed after completion of today's work (after taking printout of all your reports and transmitting DET data).

Logout of Sanchay Post in all systems.

Clear log files for all your SB databases using DBAnalyzer.

Take backup of all the SB database and keep the backup files safe.

In your server, Goto SQL Enterprise Manager.

Create a new database with the name 'BPRO_NEW'

Import all the tables from BPRO to 'BPRO_NEW' using the option 'Created objects' (3rd option) in Data Export & Import wizard.

Create a new database with the name 'POST_NEW'.

Import all the tables from POST to 'POST_NEW' using the option 'Created objects' (3rd option) in Data Export & Import wizard.

Create a new database with the name 'BPLOG_NEW'

Import all the tables from BPLOG to 'BPLOG_NEW' using the option 'Created objects' (3rd option) in Data Export & Import wizard.

Detach the databases, 'BPRO', 'BPLOG', 'POST'.

Detach the databases 'BPRO_NEW', 'POST_NEW', 'BPLOG_NEW'.

Attach the databases 'BPRO_NEW', 'POST_NEW', 'BPLOG_NEW' as 'BPRO', 'POST', BPLOG' respectively.

Do defragmentation of the drive in which you are having the database files.

Run DBAnalyzer. Select 'DBUtilities >> Update to SQL 2000' option and enter SA password and click on 'OK'. Then, select the SB databases one by one and click on 'Update'. Intimate results.

Regards,
SDC. CHENNAI.

Related Posts Plugin for WordPress, Blogger...
Related Posts Plugin for WordPress, Blogger...