Problem:- Sanchay Post work slowly:-

+Solution:-

Run DBAnalyzer. Select 'DBUtilities >> Clear Log Files' option and click on 'OK'. Then, select the SB databases one by one and click on 'Update'.
                           

                             If above Solution not solve the Problem then Use this solution.




Run DBAnalyzer. Select 'DBUtilities >> Check Database Consistency' option and run it for all databases

                                     If above Solution not solve the Problem then Use this solution.

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'. 



Thanks:sdc chennai & 

Published by: http//www.purneahpo.blogspot.in