Problem:- Sanchay Post work slowly:-

Friday, 3 February 20120 comments

+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



Share this article :

Labels

/Accountant (4) /DA (3) /Exam (3) /I.tax (1) /IPo (2) /Interest Calculator (4) /Leave (1) /ORDERS (1) /PM Gr-1 (8) /PM Gr.-1 (1) /Rail Reservation (1) /Railway (1) /Update-2 (1) /Update-3 (1) /tv (1) ACCOUNT PBS/PACS (1) ADHAR(UID) (3) ALLOWANCES (2) ANSWER KEY (1) Accountant/question Paper (1) Admit card/PM Grade1 (2) Allowances.Empoly News (1) BANKING (1) BOOK FOR DEPARTMENTAL EXA (3) BROADBAND (1) BSNL (1) CCBridge Vrs.6.0 (2) CGHS Health Tips Staffs and Welfare (3) COMPUTER AND HARDWARE (10) Clear Log Files........ (1) Computer Guidlines (5) Cricket (1) Current Afairs (1) Customer care news (8) DB - Analyzer (19) DEPARTMENTAL ORDER (4) Departmental New (1) Departmental News (71) Do software (1) Dop News /RMS (1) Dop News pension (1) Dte Order/Tfr.and Posting (1) ECS SOFTWARE (1) EVENT (1) Employees News (53) Employees News/Education (2) Empolyment News (8) Exam/Result (21) F (1) GDS (1) GPF (3) General Issue (2) General Knowledge (12) General Knowledge/cheque (1) Gold coins (3) HCL compaint (1) Hardware/security Tips (1) Health Tips (2) IMO (1) INTERNATIONAL ARTICLS WEB (1) INTRES (2) IPO (2) IPO SOLVED PAPER (1) IPO/ASPOs (15) IPS Web (1) Income tax (2) Interest Calculator (2) Internet tips (2) LGO PAPER (2) Leave Rule (2) MODEL PAPER (37) MODEL PAPER/IPO (19) MODEL PAPER/PM GR-1 (21) MOF_Rat (1) Mail (1) Meghdoot 7.0 (4) Mobile Tip (4) Money Gram IMTS (1) NEW (1) NEWS (41) NPS (5) Negative list (1) New Pension Scheme (2) News Railway (6) News Tax (1) News Tchnology (1) News:-Increament (1) OTHERS (35) Order (3) PA/SA (6) PLI and RPLI (7) PM Gr.-1 (1) POST BANK OF INDIA (3) POSTAL ABBREVIATIONS (1) POSTAL HISTORY (1) PS Group/question Paper (1) Pass Book Printer (1) Pension staffs and welfare (2) Point of Sale (6) Postal Information (4) Postal Insurance (1) Postal News (1) Postman (1) Postman Module (1) Postmaster (2) Postmaster Cadre (7) QUESTION PAPER2011 (1) QUESTION PAPER2012 (1) Qestion Paper/2012 (1) R LIST (1) R-Net (2) Recovery tips SQL (5) Recruitment PA/SA Form (3) Result (5) Result/IPO (2) Rulling and low (2) SAVING BANK (27) SB ORDER (8) SBCO (5) SERVICE TAX (1) SPEED NET (14) SPEED POST/ORDER (4) SQL (7) SUB ACCOUNT (3) SYLLABUS FOR PA/SA (1) Server/Backup (2) Solve Paper PM-1 (3) Solve Paper PS GR B (1) Staffs and Welfare (7) Study Materials (8) TDS (2) TOOL (6) Tech News (6) Tech tips and Tricks (13) Treasury (1) Trouble shooting (1) Union News (6) Update/Sanchay Post (15) WUMT POs (1) Window Server (1) Windows (4) Windows Tips (4) Windows xp (1) Workfow............ (1) budget (2) e Services (3) e services Meghdoot7 (3) eMO (3) eMO ResetRegistration (1) ePayment (1) latest software (6) oder/DA (5) operating (1) sanchay post (22) security Tips (1) syllabus /pmgr1 (1) upsc (1)
 
Support : Creating Website | Johny Template | Mas Template
Copyright © 2011. PURNEAHPO - All Rights Reserved
Template Created by Creating Website Published by Mas Template
Proudly powered by Blogger