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