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]
Subscribe to:
Posts (Atom)
