Tuesday, 10 April 2012

Automatic back up of SQL 2008 EE database



Launch Management Studio and connect to the SQL server instance that contains the database that you want to back up. Right click on the database and then in the menu choose Tasks - Back up... This will open up a window where you can choose your backup options. Click on the "Script" button near the top and select the "Script Action to File" option. Save the File.
Now,ceate a Schedule Task to Run the Backup Script
a) Open up Windows Task Scheduler. b) Create a new Task using the wizard, when asked to select a program browse to C:\Program Files\Microsoft SQL Server\100\Tools\binn\SQLCMD.exe
c) There are 2 arguments that need to be set:
-S \SERVER_INSTANCE_NAME -i "PATH_OF_SQLBACKUP_SCRIPT"
where SERVER_INSTANCE_NAME is the name of the instance of SQL server that contains your database e.g. (local) and PATH_OF_SQLBACKUP_SCRIPT is the path of your backup script e.g. "C:\Program Files\Microsoft SQL Server\DatastoreBackup.sql"
d) Adjust the task to run at the desired times.

via-http://srfix.blogspot.in

Central Civil Services (Leave) (Third Amendment) Rules, 2012

Central Civil Services (Leave) (Third Amendment) Rules, 2012.
[TO BE PUBLISHED IN THE GAZETTE OF INDIA, EXTRAORDINARY,
PART II, SECTION-3, SUB-SECTION (I)]
Government of India
Ministry of Personnel, Public Grievances and Pensions
Department of Personnel and Training
NOTIFICATION
New Delhi, the 4th April, 2012.
G.S.R.....- In exercise of the powers conferred by the proviso to article 309 read with clause (5) of article 148 of the Consititution and after consultation with the Comptroller and Auditor General of India in relation to persons serving in the Indian Auditor and Accounts Department, the President hereby makes the following rules further to amend the Central Civil Services (Leave) Rules, 1972, namely:-

1. (1) These rules may be called the Central Civil Services (Leave) (Third Amendment) Rules, 2012.

(2) They shall come into force on the date of their publication in the Official Gazette.

2. In the Central Civil Services (Leave) Rules, 1972, (hereinafter referred to as the said rules), in rules 43-AA, the existing "Note" shall be numbered as "Note I" and after Note I as so renumbered, the following note shall be inserted, namely :-

Note 2:- "Child" for the purpose of this rule will include a child taken as ward by the Government servant, under the Guardians and Wards Act, 1890 or the personal law applicable to that Government servant, provided such a ward lives with the Government servant and is treated as a member of the family and provided such Government servant has, through a special will, conferred upon that ward the same status as that of a natural born child".

3. In the said rules, in rule 43-B, the following note shall be inserted, namely:

'Note :- “Child” for the purpose of this rule will include a child taken as ward by the Government servant, under the Guardians and Wards Act, 1890 or the personal Law applicable to that Government servant, provided such a ward lives with the Government servant and is treated as a member of the family and provided such Government servant has, through a special will, conferred upon that ward the same status as that of a natural born child".
[F.No 13026/5/2011-Estt.(L)]
sd/-
(Mamta Kundra)
Joint Secretary to the Government of India
Source: www.persmin.nic.in
[http://circulars.nic.in/WriteReadData/CircularPortal/D2/D02est/13026_5_2011-Estt.L-04042012.pdf]

New Sanchay Post 6.6.1 Patches updated on 10.4.2012



Patches for Sanchay Post Version 6.6.1  ( as on 10/04/2012)
Sl.No. 
Details
Copy to
Folder
Uploaded on
1
Server / Node
DBAnalyzer
26/03/2012
2
Server / Node
DBAnalyzer
09/04/2012
3
All systems with Sanchay Post Software, running the respective modules.
SP5\OT
10/04/2012
4
SP5\SOSB
02/04/2012
5
Miscellaneous (Unzip & copy to OT, SOSB, DE\SB, DE\NS, DE\PF, NR\DE, NR\SD, SD\SB, SD\NS, SD\PF)
10 subfolders under SP5
10/04/2012

MSDB RECREATE IN SQL 2005

If your msdb goes suspect then you have two choices, restore it from a backup or recreate it (and then recreate any scheduled jobs). Obviously everyone has a comprehensive and valid set of backups, right? If only...
Of course, the very first thing you do is work out why it went suspect in the first place and take any necessary steps to stop it happening again.
Now you'd hope that if you don't have a valid msdb backup then you can at least run repair on it and so you don't lose everything in there. Well, that works as long as the transaction log isn't damaged. Ok, but then surely we can stick the database into the now-documented emergency mode (alter database dbname set emergency) and run emergency mode repair? (dbcc checkdb (dbname, repair_allow_data_loss) in emergency mode). Nope, msdb can't be put into emergency mode.
So, you're out of options and you're going to have to recreate msdb. Here's what to do (change the directory paths to suit your installation):



  1. Detach the damaged msdb. You can't just detach msdb because you're not allowed to detach system databases. However, you can if you start the server with trace flag 3608. I did this by shutting down the server, navigating to the directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn' and doing the following: start sqlservr.exe -c -T3608

   2.   Move or rename the damaged msdb files (msdbdata.mdf and msdblog.ldf in the
        'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory)
   3.   Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL       Server\MSSQL.1\MSSQL\Install' directory

4.Shutdown and restart the server without the 3608 trace flag
This works on SQL Server 2000 as well.
Hopefully you'll never have to do this but if you ever do, let me know how it goes for you.

Do’s and Don’ts for Pensioners and Family Pensioners



 1. A copy of every communication regarding pension is required to be endorsed to the pensioner by each node of pension delivery. Please ensure that your full contact postal address (preferably with PIN code) is always updated. Promptly intimate any changes of address to: -
a. Your Bank Branch
b. The Head of Office and the PAO in the Ministry from where you retired;
c. Central Pension Accounting Office
2. There should be proper nomination for pension account. Please retain the acknowledgement received from the bank carefully. It is advisable to open a joint account with your spouse if you are pensioners so that she/he does not hardship later.

3. Please direct your bank branch with proof establishing your Identity for first appearance at Paying Branch along with the copy of the special seal authority.
4. CPAO has sent two halves of PPO – the pensioner’s and the Bank’s. Your half of the PPO is to be handed over to you by your Bank branch when they call you for verification. Your signature will be obtained on their half for their record.
5. Please produce proper and acceptable evidence of eligible savings from time to time for the purpose of Income Tax calculation by the Bank.
6. Please collect Certificate of Income from pension from bank at the close of financial year, even if income tax is not deducted from the pension. Please collect form-16- income tax was deducted.
7. Please furnish Life Certificate early in the month of November every year.
8. A pensioner who produces a life certificate in the prescribed form in Annexure -XVII signed by any person specified hereunder, however, is exempted from personal appearance- :-
(i) A person exercising the powers of a Magistrate under the Criminal Procedure code;
(ii) A Registrar or Sub-Registrar appointed under Indian Registration Act;
(iii) A Gazetted Government servant;
(iv) A Police Officer not below the rank of Sub-Inspector in -charge of a Police Station; Offices;
(vi) A Class-I officer of the Reserve Bank of India, an officer (including Grade II officer) of the State Bank of India or of its subsidiary;
(vii) A pensioned Officer who, before retirement, exercised the powers of a magistrate;
(viii) A Justice of Peace;
(ix) A Block Development Officer, Munsif, Tehsildar or Naib Tehsildar;
(x) A Head of Village Panchayat, Gram Panchayat, Gaon Panchayat or an Executive Committee of a Village;
(xi) A Member of Parliament, of State legislatures or of legislatures of Union Territory Governments /Administrations.
(xii) Treasury Officer.
In the case of a pensioner drawing his pension through a Public Sector Bank the life certificate may be signed by an officer of a Public Sector Bank. In the case of a pensioner residing abroad and drawing his pension through any other bank included in the Second Schedule to the Reserve Bank of India Act, 1934, the life certificate may be signed by an officer of the Bank, A pensioner get exemption from personal appearance subject to production of Life Certificate signed by the above mentioned officer of the bank.
A pensioner not resident in India in respect of whom his duly authorized agent produces a life certificate signed by a Magistrate, a Notary, a Banker or a Diplomatic Representative of India is exempted from special appearance.
9. Non-employment Certificate/Re-employment Certificate should also be furnished every year in the month of November/May & November in case of retired Group ‘A’ officer.
10. Please apply in a prescribed proforma to the paying branch for restoration of commuted portion of pension on completing 14 years and 11 months in case your bank does not have a CPPC.
11. Please provide the Pensioner’s half of the PPO to your paying Bank Branch in the case of revision of pension for entry of enhanced pension with break up in this half.
12. Please ask for a due and drawn statement from your bank branch in case you have received any arrears in a lump sum.
13. Please ask for a pension slip with break up of in case of any doubt from bank branch
14. If Pensioner’s half is lost, worn or torn, a written request is to be immediately made to your paying Bank branch alongwith Pensioner’s half of PPO (if available).
15. Please keep all your Pension related documents including Pensioner’s half of PPO, safely, as these are important documents.
16. For any clarification on pension payments, contact your bank branch grievance officer of the Bank or CPAO Toll Free /Call Centre 1800 11 7788.
1. Do not delay in submitting the Pension Papers before retirement as it ultimately effects the time schedule to be followed by the various offices as under: -
(i) Pay & Accounts Officer issuing PPO – Despatch of PPO by PAO to the CPAO on the last working day of the month preceding the month of retirement
(ii) Central Pension Accounting Office (CPAO) – Despatch of PPO by CPAO to Link Branch of PSB by 20th of the month of retirement
(iii) Link Branch – Despatch of PPO by Link Branch to paying branch by 23rd of the month of retirement.
(iv) Paying Branch – Paying Branch will complete all formalities and ensure that the pension has been credited to the pensioner’s account on the last date of the month.
2. Please do not provide address and contact number which is likely to change in immediate near future. Please update your address by informing your bank branch, PAO, CPAO and DDO of the ministry you retired from.
3. In case you wish to change your bank or bank branch for pension disbursement, do not close your pension account unless new account is confirmed for pension disbursement.
4. Please do not fail to check whether you are receiving full pension/family pension authorized by the Govt. of India to you including is related pension with Dearness Relief if you are aged 80 and above.
5. Please do not forget that under the scheme of pension department through authorized banks, banks are required to pay pension to each pensioner by the last day of the month and the Govt. of India fully

Courtesy : http://www.gconnect.in/
via-sapost.blogspot.in

DOPT clarifies the term ‘Year of availability’ in Seniority Issue



It is clarified by DOPT that the term ‘Year of Availability’ for the purpose of relative seniority of direct recruits/ promotees would be same as prescribed in the model calendar for DPC
 
F.No.20011/1/2006-Estt. (D)
Government of India
Ministry of Personnel, Public Grievances and Pensions
(Department of Personnel as Training)
North Block, New Delhi Dated the 3rd April, 2012
OFFICE MEMORANDUM


Subject:- Consolidated instructions on seniority contained in DOP&T’s O.M. No. 22011/7/ 1986-Estt. (D) dated 03.07.1986-Clarification regarding.

     The undersigned is directed to refer to this Department’s consolidated instructions contained in O.M. No. 22011/ 1/2008-Estt. (D) dated 11.11.2010  laying down the principles on determination of seniority of persons appointed to services/posts under the Central Government and to state that a large number of references have been received seeking clarifications on ‘year of availability’ in fixation of relative seniority of promotees and direct recruit officers who had joined service in the different calendar year but in the same financial year.
2.    The issue has been examined in consultation with UPSC. The model calendar (time schedule) for DPCs as contained in this Department’s O.M. No. 22011/9/98-Estt. (D) dated 8th September, 1998 suggests time-frame for conducting/completing formalities for DPC meeting/promotions. As per this 0.M., Ministries/Departments that are following financial year i.e. 1st April to 31st March of next year for completion of confidential reports (now APARs) should get the select panel approved for the next financial year by 31st March of the previous financial year. Similarly, those Ministries/Departments, which follow calendar year for completion of confidential report (now APARs) i.e., 1st January to 31st December, should get the select panel approved by 31st December of the preceding Calendar Year.
3. It is hereby clarified that the year of availability for the purpose of relative seniority of direct recruits/promotees would be same as prescribed in the model calendar for DPCs i.e.
(i) 1st April to 31st March of the next year where confidential reports (now APARs) are completed financial year-wise.
(ii) 1st January to 31st December where confidential reports (now APARs) are completed calendar year-wise.

Courtesy : http://www.gconnect.in/

Calculation for total no of Earned leave at credit - Study material for Accountant Examination


Fifteen Days of EL should be credited into account  on the first  January and  First July of every year

The credit to be afforded will be reduced  by 1/10 th of extraordinary  leave  availed  and/or period of dies non   during the previous half year

Eg  :    Dies non for 15  days  from     01.02.2009        

Next credit   15 Days     on  01.07.2009

Calculation   =    15  *1/10   ( 15-1.5  )   rounded to  14 Days  crdit

  
EL can be accumulated  up to  300 Days in addition to the  number of days for which enhcashment has  been  allowed along with LTC
The credit for  the half year in which  a government servent is appointed  will be  afforded at the rate of  2 ½ days  for each  completed calander month of service which he is likely to  render in the calander  half year in which he is appointed

Eg  :   Mr  X is  appointed on     12.02.2008       Then  Total  no of leave  credited   on 01.07.2008 is calculated as follows    

Completed calander month  from 12.02.2008   to  30.06.2008   Four months

So
           Total credit  of EL =  (4 *2 ½ )    =  10 Days



While affecting credit fractions  of a day  should be  rounded off to the nearest day Eg : 7 ½  days  to be rounded as 8  Days  
EL  on account of unavailed  Joining time 

Unavailed  joining  time   I e  Number of  days  admissible ( Subject to  maximum  15 Days ) reduced by  the  actual number of days  availed  , shall be credited  to Earned Leave account

Condition for  the  above 
1.      The Government servant   is ordered to  join  the new Post  without availing full admissible joining time
2.     Proceeds alone to the  new place  and joins the post  without availing  full  joining time
3.    The credit of earned leave  + the unavailed joining time credited should not exceed 300 Days

http://nfpemavelikaradivision.blogspot.com

HOW TO OPEN WHEN WUPOS (WESTERN UNION) LOCATION ID IS LOCKED

In WUPOS when your Location ID is Locked due to making wrong attempt with wrong password the following message will appear 


Solution :

Step 1 : Collect your Account ID i.e. AAA123456 & Login ID i.e. 111

Step 2 : Call To Western union Call center (India) 1800-425-1851

Step 3 : log your complaint & don't forget to take complaint ID i.e. 123456

Step 4 : After 30 Min. Login your ID with RESET100 Procedure 
                RESET100 Procedure means
                LOG IN AS USERNAME :
( WHICH IS COMBINATION OF LOGIN ID & ACCOUNT ID ) i.e. 111AAA123456
            & PASSWORD : RESET100

Step 5 : Set Your New Login Password