Click here to view No: S.11045/23/2013-CGHS D.II/HEC/CGHS(P), dated 30.04.2013 issued by Ministry of Health and Family Welfare, Govt. of India
Monday, 20 May 2013
How to resolve 'database is in use' error while restoring SQL Server database
Have your SQL Database Restoration get failed with a message saying the 'database is in use'. This error occurs when any other users are connected to the database then the restore get failed & shows following error message:
Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
To resolve this issue, you need to drop all other connections or the database that user are using should to be changed so that they will not use that database that you are going to restore. You can use sp_who2 or SSMS to see what connections are using the database.
To resolve this issue:
1. Put the database in single-user mode
In SQL Server 2005 you do this by right clicking on the database - > properties and changing the relative attribute from multiuser to single user. After performing restore operation set again it to multiuser.
Or you can also use this TSQL command:
use master
alter database xyz set single_user with rollback immediate
restore database xyz ...
alter database xyz set multi_user
2. Set your database offline:
If it is Still giving same error message after keeping database in single_user mode then you should just set it offline before running the restore option. This is the easiest way to kill all connections to the SQL Server database:
use master
alter database MyDatabase set offline with rollback immediate
After that you can successfully restore your SQL Server Data base & all authenticated SQL Server database users can connect to the database again.
Courtesy : http://bnjho.blogspot.in
Details of Abolished Post and Shortage of Staff in Postal Department
GOVERNMENT OF INDIA
MINISTRY OF COMMUNICATIONS AND INFORMATION TECHNOLOGY
LOK SABHA
UNSTARRED QUESTION NO 6875
ANSWERED ON 8.05.2013
SHORTAGE OF STAFF IN POSTAL DEPARTMENT
6875 . Smt. DARSHANA VIKRAM JARDOSH, ASHOK TANWAR
Will the Minister of COMMUNICATIONS AND INFORMATION TECHNOLOGY be pleased to state:-
Will the Minister of COMMUNICATIONS AND INFORMATION TECHNOLOGY be pleased to state:-
(a) whether the Government has abolished 17093 posts across the cadres in the department of posts during the period from 2005 to 2008;
(b) if so, the details thereof and the reasons therefor;
(c) whether there is a shortage of staff in various cadre in the department and in the post offices in the country;
(d) if so, the details thereof, State-wise; and
(e) the steps proposed to be taken to fill the vacant posts expeditiously, so as to ensure prompt and quality service to customers?
ANSWER
THE MINISTER OF STATE IN THE MINISTRY OF COMMUNICATIONS AND INFORMATION TECHNOLOGY (Dr. (SMT) KILLI KRUPARANI)
(a) Yes, Madam.
(b) The details of abolition of posts are placed at Annexure-I. The reasons for abolition of posts were in accordance with Department of Personnel & Training OM No. 2/8/2001-PIC dated 16.5.2001 vide which the Scheme of Optimization for Annual Direct Recruitment Plan was launched. As per this Scheme, the direct recruitment was to be limited to 1/3rd of the direct recruitment vacancies arising in a year subject to a further ceiling that it does not exceed 1% of the total sanctioned strength of the Department. The remaining direct recruitment posts were required to be abolished.
(c) Manpower requirement and regular recruitment is an ongoing process in the Government. Shortage of staff in the Department and in the Post offices in various cadres arises mainly due to promotion, retirement, death, leave or transfer.
(d) Does not arise in view of (c) above..
(e) Vacancies in the Department are filled up by promotion or by direct recruitment as per extant procedures regularly.
ANNEXURE-I
Abolition of posts across various cadres in the Department of Posts during 2005-2008.
Year
|
No. of direct recruitment vacancies abolished
|
2005
|
2121
|
2006
|
5426
|
2007
|
4957
|
2008
|
4589
|
Total
|
17093
|
Source: www.loksabha.nic.in
[http://164.100.47.132/LssNew/psearch/QResult15.aspx?qref=141137]
Friday, 17 May 2013
No LPG to houses with multiple-connections from June 1
NEW DELHI: Cooking gas or LPG supplies to households having unverified multiple connections will stop from June 1, state-owned oil firms announced today.
The three state-owned fuel retailers have been "directed to stop supplies of LPG refills to households having multiple- connections for which no KYC (Know Your Customer) details have been received, with effect from June 1," a statement issued by Indian Oil Corp, the nation's largest oil firm, said.
No transactions, including delivery of non-subsidised cylinders, will be permitted in such cases once such connections have been blocked. IOCBSE 0.63 % said all multiple LPG connection holders have been identified and intimated. All three firms, IOC, Hindustan PetroleumBSE 1.96 % ( HPCLBSE 1.96 %) and Bharat Petroleum (BPCLBSE 1.41 %) are sharing data on LPG customers.
Customers whose name figure on the list of multiple connection holders need to submit their KYC details along with proof of identity and proof of address immediately to their LPG distributors to continue receiving uninterrupted quota of subsidised cylinders, IOC said.
Other customers whose names do not appear in the list need not submit their KYC details as of now.
"The oil companies are advising all multiple-connection holders to submit their KYC details, pertaining to the LPG connection they wish to retain, immediately to their LPG distributors," the statement said adding customers have been advised to surrender excess or multiple connections.
Though the deadline for submission of KYC was December 31, 2012, KYCs are being accepted and LPG connections are being regularised for supply of subsidised cylinders till date, it added.
Source : Economictimes.com
Subscribe to:
Posts (Atom)
