Saturday 7 July 2012

SQL SERVER 2000-MASTER DATA BASE REBUILDING.

One day when I started the server I got a message. Microsoft SQL server not starting. While Restarting the SQL server it is not possible. Mostly SQL Server is not starting because master database is corrupted. Since SQL server is not started we cant restore the master database.
 
If you have SQL Server 2000 CD then you can restore the master database. Insert the SQL SERVER 2000 CD. Then go to
MY Computer-----
C DRIVE------Program Files-------Microsoft SQL Server-----------80-----------Tools----------Binn---------rebuildm.exe
Double click on rebuildm.exe then you have to show the path of DATA folder from the CD
(ie Browse the CD open the folder---*86--------DATA)
After this you can connect/ start SQL server. Then restore the master database with the backup(Previous Days). Then you can re start Sql server 2000. and start working all the Applications
 
 
 
 
courtesy:saparavur

Msdb Database Suspected\Corrupted-Solution (SQL 2000&2005)













In Sql server 2000
you start the server with trace flag 3608.In SQL Server Enterprise Manager, right-click the server name, and then click Properties.
  1. On the General tab, click Startup Parameters.
  2. Add the following new parameter:
    -c -m -T3608
After this restart the sql server and detatch the msdb database and move the mdf and ldf files from the default folder C:\Program Files\Microsoft SQL Server\MSSQL\DAta
Then recreate msdb file by executing in new query window
instmsdb.sql (C:\Program Files\Microsoft SQL Server\MSSQL\Install)
Then remove-c -m -T3608 from the startup parameters in SQL Server Enterprise Manager
Then stop and restart the sql server 2000
and then recreate the maintenance plans

In SQL Server 2005
Detach the msdb database and install/create new msdb database. This will solve the problem. But the problem is that SQL Server 2005 does not allow to detach a system database. This will be solved by the following
another way is (you start the server with trace flag 3608. )
Start--------------Sql Server 2005-------------Configuration Tools----------SQL Server Configuration Manager

Then click on SQL server 2005 services.-----On the right side----Right click on SQL Server----Select Properties
Click on the Advance Tab and change the Parameters of Start up Parameters ie please add -m;-c;-T3608 in front of the existing parameter.
Then restart SQL server
detach the msdb database by query
use master
go
sp_detach_db ‘msdb’
go
and click Execute
Then move the existing mdf and ldf files of msdb from” C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

 
Then recreate msdb files open the nstmsdb.sql in a new query window and execute.The file is located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
Then your msdb is restored. Before restarting the sql server remove the parameters (-m;-c;-T3608 )Then restart the sql server. Be and recreate the new maintenance plan.
 
via-saparavur.blogspot.in

Collection of Model Questions and Study Materials for various type of Departmental Examinations

 
Published by:  http://katiharho.blogspot.in
Download Link
Title
Related to 
Questions related with law
IPO/PM Cadre
Postal  Volume  V
IPO/PM /LGO
Computer terms
IPO/PM
Constitution
IPO/PM
CRPC
IPO/PM
DOB of famous Indian leaders
IPO/PM
General English
IPO/PM
GK
IPO/PM
GK
IPO/PM
GK
IPO/PM
GK
IPO/PM
Postal volume
IPO/LGO
lAW
IPO/PM
PO Guide
LGO
Postal  Volume
IPO/LGO
PO Savings account
IPO/PM/LGO
Postal Volume
IPO/PM
Terms in law
IPO/PM
Terms  -Postal
LGO
Postal Orgnisation
IPO/PM/LGO
Our service
IPO/PM/LGO
Philately
IPO//PMLGO
Year of Service
IPO//PM/LGO
CCS Leave Rules
IPO/PM
Consumer Protection
IPO/PM
Discovery
IPO/LGO
Material Management
IPO
Material Management II
IPO
Office Procedure
IPO
RTI
IPO
Law
IPO
Year of birth and death
IPO/PM
Who is Who
IPO/PM

Source :   http://nfpemavelikaradivision.blogspot.com

India Post recorded deficit of Rs 5,794 crores during 2011-2012

Mirroring signs of revival, the Department of Posts (DoP) has registered the highest decline in deficit in more than 10 years at Rs 550.73 crore in 2011-12 on the back of increase in revenues, mainly from financial services.
            Total revenues of the department in 2011-12 rose by 13.62 per cent to Rs 7,910.51 crore while expenditure stood at Rs 13,705.4 crore, leaving a deficit of Rs 5,794.89 crore.
            In the previous fiscal, DoP had revenues of Rs  6,962.33 crore and expenditure of Rs 13,307.95 crore, reflecting a gap of Rs 6,345.62 crore.
            DoP's deficit had jumped over 80 per cent to 6,641.30 crore in 2009-10 from 3,593.09 crore in 2008-09 due to implementation of the Sixth Pay Commission's recommendations.
            “In the last one year we have developed an integrated strategy to make India Post, commercially and socially relevant. The financial performance of the last year indicates that we have succeeded to an extent. But a lot more need to be done,” Minister for Communications and IT Kapil Sibal told the news agency.
According to the Financial Performance report prepared by Department of Posts for 2011-2012, revenues from financial services grew by 20.8 per cent at Rs 4,304.07 crore in 2011-12 compared to Rs 3,562.77 crore in FY'11.
            Revenue from postal operations grew by 6.08 per cent to Rs 3,606.44 crore in 2011-12 from Rs 3,399.56 crore it registered in FY'11.
            Sibal said that he is expecting revenue of DoP to grow by 20 per cent in the current financial year.
            “This financial year we are targeting revenue increase of plus 20 per cent. I am happy that India Post is moving in the right direction. Now we need to increase our speed,” he said.
            DoP has appointed Boston Consulting Group to prepare an appropriate business structure for the emerging and premium services of India Post.
            The postal department has floated expression of interest to appoint a consultant for preparing detailed project report (DPR) of its ambitious Post Bank projects and this report is expected to be finalised by end of this calendar year.
            “The Post Bank project will rejuvenate financial services offered through post offices,” Sibal said.DoP has already announced to set-up 1000 ATMs across country as part of its financial services.
            Sibal has also asked DoP introduce premium logistics services in select 80 to 90 cities within six months to tap the expanding e-commerce market in the country and enhance its revenue by 15 per cent.
 
Source : PTI 05.07.2012