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.
Assam 12th Exam Result 2013
Assam 12th exam result 2013 / Assam HSSLC - Higher Secondary – Class 12 Results 2013 to be announced on Monday 20th May 2013 at 10 AM
Assam 12th exam result 2013 likely to be announced on 20th MAY, 2013. AHSEC Assam Higher Secondary Education Council will release results in the official websites.
Assam 12th examination was conducted in the month of March / April 2013. Around 4 lakh candidates had appeared for Assam 12th examination. Presently they are waiting for results.
The Assam 12th Candidates can check results here :
Assam 12th exam result 2013 will be available in the following websites :
Click here to check Assam 12th Results 2013. High Secondary School Leaving Certificate Examination (HSSLC & AHM) Results 2013, SEBA, Assam Results will be Available on 20/05/2013 at 10 AM
SEBA conducted Higher Secondary School Leaving Certificate (HSSLC) Examination in 26 districts across 823 centres in the state of Assam. These districts include Baksa, Barpeta, Bongaigaon, Cachar, Chirang, Darrang, Dhemaji, Dhubri, Dibrugarh, Dima Hasao, Goalpara, Golaghat, Hailakandi, Jorhat, Kamrup, Karbi Anglong, Karimganj, Kokrajhar, Lakhimpur, Morigaon, Nagaon, Nalbari, Sivasagar, Sonitpur, Tinsukia and Udalguri.
Headquartered in Bamunimaidam, Guwahati, the AHSEC is a part of Assam Board of Higher Education (SEBA) and was established under the Assam act xxv of 1961. The main aim of the council is to provide higher education with the practical and valuable knowledge to the students. Presently the territory of the State of Assam is the jurisdiction of the Board.
For more details you can contact the following address:
Assam Higher Secondary Education Council Bamunimaidam,
Guwahati-781021
Guwahati-781021
=Answer Key of Postal/Sorting Assistant Exam held on 19 May 2013- General Awareness Section
Solved Questions of Postal/Sorting Assistant Exam held on 19 May 2013
General Awareness Section: Questions with Answer Key
Circles Covered: Delhi, Jammu & Kashmir, Punjab, Uttarakhand and U. P. circles
Prepared by: currentaffairs4examz.blogspot.com
Published by www.sapost.blogspot.com
Q1. The minimum number of members whose presence is essential for transacting the business of either house-Lok Sabha or Rajya Sabha shall be:
(A) 100members
(B) 1/2 of the total number of members of the house
(C)1/5 of the total number of members of the house
(D)1/10 of the total number of members of the house
Ans. (D)1/10 of the total number of members of the house
Q2. When the branch of a tree is shaken violently, the leaves fall. This happening can be explained by:
(A) Joules 2nd law of motion
(B) Newton's 3rd law of motion
(C) Joules ist law of motion
(D) Newton's 1st law of motion
Ans. (D) Newton's 1st law of motion
Q3. When 'Sepoy Mutiny or the Great Revolt' took place, who was the Viceroy of India
(A) Lord Canning
(B) Lord Minto
(C) Lord Rippen
(D) Lord Curzon
Ans. (A) Lord Canning
Q4. Which layer of the atmosphere is closest to the Earth:
(A) Stratosphere
(B) Ionosphere
(C) Mesosphere
(D) Troposphere
Ans. (D) Troposphere
Q5. Which among these is a credit rating agency:
(A) NSE
(B) BSE
(C) ICRA
(D) SEBI
Ans. (C) ICRA (investment information and credit rating agency of India limited.)
Q6. Which of the following gases are given out during Photosynthesis?
(A) Nitrogen
(B) Hydrogen
(C) Oxygen
(D) Carbondioxide
Ans. (C) Oxygen
Q7. Name the king of Kannauj whose daughter Sanyogita was abducted by Prithviraj Chauhan from her Swayamvar?
(A) Jayadev
(B) Lakshman sen
(C) Bhoj
(D) Jaychand
Ans. (D) Jaychand
Q8. The thumb nail get fixed easily into the wood because:
(A) more force works on less area
(B) less force works on more area
(C) more area work on less force
(D) more area work on more force
Ans. (A) more force works on less area
Q9. As per protocol second highest post of after President in India
(A) Prime Minister
(B) Vice President
(C) Chief Justice
(D) Leader of opposition in Lok Sabha
Ans. (B) Vice President
Q10. Who is the Deputy Chairman of Rajya Sabha at Present:
(A) Najma Heptulla
(B) Pratibha Patil
(C) K. Rahman khan
(D) P.J. Kurien
Ans. (D) P.J. Kurien
Q12. What is the status of India in the world in terms of steel production?
(A) 7th
(B) 10th
(C) 5th
(D) 6th
Ans. (C) 5th
Q13. Bula Chaudhary is related to which sport event:
(A) Cricket
(B) Badminton
(C) Swimming
(D) Golf
Ans. (C) Swimming
Q14. Which of the following act as decomposers in an ecosystem?
(A) Putrefying bacteria
(B) Rhizobium bacteria
(C) lactobacillus bacteria
(D) Cyanobacteria
Ans. (B) Rhizobium bacteria
Q15. Which sport personality has won the the Indian Grand Prix 2012 at the Buddha International Circuit for the second time?
(A) Mark Weber
(B) Lewis Hamilton
(C) Sebastion Vettel
(D) Fernando Alonso
Ans. (C) Sebastion Vettel
Published by www.sapost.blogspot.com
Q16. Finance ministry has kept some services under the negative list which means:
(A) Service tax would be levied @ 12% on those services
(B) Service tax would be levied by State Government on services in negative list
(C) Service tax would not be levied against those services
(D) Service tax would be levied at highest rate on those services
Ans. (C) Service tax would not be levied against those services
Q17. How many districts of the country were initially covered under the Direct Benifit transfer scheme started from January 1,2013?
(A)43
(B)34
(C)20
(D)29
Ans. (C)20
Q18. Which among the following have been conferred with Rajiv Gandhi Khel Ratna Award in 2012?
(A) Mary Kon and Anup Kumar
(B) Saina Nehwal and Sushil Kumar
(C) Deepika Kumari and Yuvraj Singh
(D) Yogeshwar Datt and Vijay Kumar
Ans. (D) Yogeshwar Datt and Vijay Kumar
Q19. Rath Yatra- This famous festival is held in?
(A) Odisha
(B) West Bengal
(C) TamilNadu
(D) Karnataka
Ans. (A) Odisha
Q20. In the 92nd constitutional amendment, how many languages were added to the 8th schedule of the constitution?
(A) 4
(B) 3
(C) 2
(D) 5
Ans. (A) 4 (Bodo, Maithili, Dogri, and Santali languages)
Q21. United Nationa has released "one women Album on the occassion of International Women's Day. Name the indian artist of that Album?
(A) Mallika Sarabhai
(B) Amjed Ali Khan
(C) A.R. Rahman
(D) Anoushka Shankar
Ans. (D) Anoushka Shankar
Q22. President appoints Chief Election Commissioner & Election Commissioners. They have tenure:
(A) Till age of 65 years
(B) 6 years, or upto the age of 65 years, whichever is earlier
(C) 5 years
(B) 6 years
Ans. (B) 6 years, or upto the age of 65 years, whichever is earlier
Q23. This State contributes 70% of India's coffee and silk. Options Given. Which is this state.
(A) Rajasthan
(B) Punjab
(C) Karnataka
(D) Assam
Ans. (C) Karnataka
Q24. Ebb & Flow is:
(A) Name of a new star
(B) Unit of measurement of a liquid
(C) A missile recently launched from Odisha
(D) Gravity Mapping satellite of NASA
Ans. (D) Gravity Mapping satellite of NASA
Q25. Who was appointed as chairman of 14th Finance Commission?
(A) Sam Pitroda
(B) P.Chidambaram
(C) Montek Singh Ahluwalia
(D) Dr. Y.V.Reddy
Ans. (D) Dr. Y.V.Reddy
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]
TN TET Syllabus, Study Material and Model Question Papers 2013 (Tamilnadu)
TN TET Syllabus, Study Material and Model Question Papers 2013 with Answers
TNTET Tamil Nadu Teachers Eligibility Test examination for the year 2013 will be announced within a week. The Candidates those who are appearing for TNTET 2013 examination can download study material given below. TNTET study material here is provided with answers. Click the following links to download study materials.
TNTET 2013 Notification - Click here
How to prepare yourself for TNTET 2013 examination - Click here
· TET PAPER II 10th SCIENCE BIOLOGY T/M QUESTIONS BY L.BABUVELAN B.T, SOKKANATHANPATTI, TIRUNELVELI DT
· NTET 6th Std TAMIL Key points by BHARATHI STUDY CENTRE,TRICHY/MADURAI.TNTET 7th Std History Key points by R.Mohan, mettu street, Uthiramerur (TET selected candidate )TET SYLLABUS, QUESTION PAPERSAND STUDY MATERIALS
· TET PAPER II 8th SCIENCE BIOLOGY T/M QUESTIONS BY L.BABUVELAN B.T, SOKKANATHANPATTI, TIRUNELVELI DT
· TET PAPER II 8th SCIENCE PHY&CHE T/M QUESTIONS BY L.BABUVELAN B.T, SOKKANATHANPATTI, TIRUNELVELI DT
RMS employee's son cleared Civil Service (Main) Examination 2012 (UPSC)
Union Public Service Commission (UPSC) on 3 May 2013 declared final result of Civil Service (Main) Examination 2013. A total of 998 candidates have been recommended for appointment to Indian Administrative Service, Indian Foreign Service, Indian Police Service, and Central Services, Group ‘A’ and Group ‘B’. CLICK HERE to see the result.
Sri Yogesh Gunaji Loke S/o Shri Gunaji Loke, Sorting Assistant, AMPC, Mumbai has declared successful in the said examination. He appeared under Roll No. 308689 and secured 963 marks.
NFPE kavalibranch Congratulating Him to have a Bright Future
No comments:
Post a Comment