Friday, 24 May 2013
SQL Database Recovery Terms
As we know in SQL Database recovery we have these three options which we use commonly:
- Restore from backup
- DBCC Command & Repair command or
- Third Party SQL Database Recovery Software
Is “REPAIR_ALLOW_DATA_LOSS” command not cause data loss: It all totally depends on corruption level. When you are using this command, you should make up your mind that you can also lose you data. That's why the option is named that - seriously.
Can we run repair without running DBCC CHECKDB: No, we can’t. Repair is an option to one of the consistency-checking commands (DBCC CHECKALLOC, DBCC CHECKTABLE, or DBCC CHECKDB
Note: DBCC CHECKFILEGROUP and DBCC CHECKCATALOG don't support repair
Is Repair fix every SQL Database corruption: No, it don’t fix, Its all depends on corruption level. There are some errors that DBCC CHECKDB cannot fix. For more detail please check this post.
Repair is safe to use on system databases: No, it’s not safe. We should never use it on master or tempdb because they cannot be put into single-user mode.
Is 'REPAIR_REBUILD' resolves every SQL Database corruption: No it’s not true. REPAIR_REBUILD only fixes problem in nonclustered indexes.
Is EMERGENCY mode repair always helps: No, it’s not repair. If there is something broken in the file-system than the command get fail.
Can we roll back repair command?: It depends. You can roll back everything if you started an explicit transaction. But users do it very rarely.
Note: EMERGENCY mode repair can never be rolled back.
Is SQL Database Recovery Software safe to use: YES, when you are using this software, you should first make a backup of your database. I always first preferred restore from backup solution so I will also recommend you it as a first step. You should only use this option when you don't have backup.
Before using any recovery step, you should be properly aware about their pros & cons. It will help you to choose better solution to recover your corrupt SQL Server database.
Source : http://data-base-recovery.blogspot.in
Top 10 things Stellar Phoenix SQL Recovery user needs to know
Recover your corrupt SQL Server Database with a dedicated software application is a SQL Recovery Software provided by Stellar. The application runs directly from your system after installing software on specified location. Here I am sharing useful information of SQL Recovery Software.
There are two types of files, mdf and ndf which manage your data in proper format. The ndf file is a secondary file, if you have a large amount of data; you probably have a secondary file (ndf) to save your data. The new feature is to recover large ndf files. Now you have no need to worry about large file recovery, Stellar SQL Recovery can also recover large corrupt ndf files. The SQL Recovery Software should run on copy of the corrupt file.
In any version of SQL Database, if you find any problem to find the corrupt mdf file then you can easily search it by using the "Find Option". Just click on this button & the application find into your system that appears immediately in list view format. You can choose the file that you want to recover from this list.
The new version of SQL Server Database launched in 2011. Another new feature is- supports to latest version of SQL Server Database that is SQL Server 2008 R2.
Fast scanning algorithms — you can recover database quickly & accurately without completing the whole recovery.
In addition to the whole process information, the new set includes separate log report after scanning database which shows all recovery process. I am eager to see how this apps sharing this process in the software.
You can also recover XML data types and XML indexes with this software.
You cannot save preview of your database in demo version. For this you have to purchase full version of the software.
You can check the preview more than one objects at a time. Click on either one to multiple objects to recover it. Save it quickly and easily on location as you like.
You should perform software updates as soon as they become available. The easiest way for users to update your software is through update button. If you are using software, when an update is available, you can see it by clicking update button the top fifth right button on the software screen. Just click on this button to install the new updates.
If any of option isn’t used by you just yet, don’t worry use it now & give your precious comments about it.
Source : http://data-base-recovery.blogspot.in
Grant of one increment in pre-revised pay scale - OM dated 19.3.2012 - clarification regarding.
Grant of one increment in pre-revised pay scale as a one time measure - OM dated 19.3.2012 [click here to view] - Clarified by finmin as "There will be no change in the revised pay as on 1.1.2006, if the revised stage with reference to the pre-revised pay after accounting for one increment in the pre-revised scale does not undergo any change as per the Fitment Table. It is also clarified that no further bunching will be allowed in such cases and no re-fixation of pay will be admissible in the revised pay as on 1.1.2006."
See reproduced text of latest OM of Finmin:-
संख्या/No. 1/1/2008-IC
à¤ारत सरकार/Government of India
वित्त मंत्रालय/Ministry of Finance
व्यय विà¤ाग/Department of Expenditure
North Block, New Delhi
Dated the 22nd May, 2013
OFFICE MEMORANDUM
Subject: Grant of one increment in pre-revised pay scale - OM dated 19.3.2012 - clarification regarding.
The undersigned is directed to invite a reference to this Ministry's Office Memorandum of even no. dated 19.3.2012 which provides that those Central Government employees who were due to get their annual increment between February to June during 2006, may be granted one increment as on 1.1.2006 in the pre-revised pay scale as a one time measure and, thereafter, will get the next, increment in the revised pay structure on 1.7.2006.
2. As per this Ministry's OM No. F. No. 1/1/2008-IC dated 30th August, 2008, fitment tables have been prescribed in Annexure-I thereto, specifying the stages of revised pay in the revised pay band with reference to each stage of pre-revised pay in various pre-revised pay scales. As per the fitment tables, the stage of revised pay in the pay band has been mentioned at the same stage in respect of two consecutive pre-revised stages of pay in cases of certain pre- revised scales.
3. This Ministry has been receiving references as to whether in cases where the fitment table provides for the same revised stage in case of two consecutive pre-revised stages in a particular pre-revised scale of pay, the benefit of bunching is admissible after grant of one increment in the pre-revised pay scale by virtue of this Ministry's OM dated 19.3.2012.
4. The matter has been considered and it is clarified that Fitment Table contained in the aforesaid OM dated 30.8.2008 is to be strictly followed for fixation of pay in the revised structure without any deviation.
5. In cases where the stages of fixation of pay in the revised pay band as per fitment table contained in the aforesaid OM dated 30.8.2008 provides for the same revised stage in the Pay Band with reference to two consecutive stages of pre-revised pay in the corresponding pre-revised scales, then in such cases due to application of this Ministry's OM dated 19.3.2012, there will be no change in the revised pay as on 1.1.2006, if the revised stage with reference to the pre-revised pay after accounting for one increment in the pre-revised scale does not undergo any change as per the Fitment Table. It is also clarified that no further bunching will be allowed in such cases and no re-fixation of pay will be admissible in the revised pay as on 1.1.2006.
sd/-
(Amar Nath Singh)
Deputy Secretary to the Government of India
Source: http://finmin.nic.in/
HOW TO FILE AN RTI APPLICATION
An RTI application can be made on a sheet of plain paper and can have any number of questions. It should be addressed to the public information officer of the department or organisation concerned. Rs.10/- should be paid as application fee by cash or through postal order, court fee stamp or demand draft. Questions should be direct and leave no room for the information officer to give vague replies. Information officer has to reply within 30 days of receipt of the application, failing which he is liable to a fine of 250 per day. Appeal can be filed with the head of the department in which the application was filed, if the information officer fails to reply within the deadline. Second appeal can be filed before the central or state information commission if applicant is not satisfied with the replies.
According to Section 2(f) of the RTI Act, information means any material in any form, including records, documents, memos, e-mails , press releases, circulars, contracts, samples, models, data held in any electronic form and information relating to any private body which can be accessed by a public authority under any other law in force.
File an RTI application in 5 simple steps:
1. Identify the department/subject of your query. Is it a state or a central subject? Keep in mind that different rules apply even though they fall under the same Act.
2. Do a little background research. Find out what information falls under the purview of the department concerned.
3. Phrase your questions wisely and precisely. Ask for a copy of the documents. Fill up the RTI application form (application form given).
4. Attach court fee stamp or Indian Postal Order of worth Rs 10 with the application and keep a copy of it with you for future reference.
5. Post your application or hand it over personally to the ‘TAPAL” also called as Inward/Outward section of the respective department.
The essential requirements of an application filed under the RTI Act are:
(a) The applicant should be a citizen of India.
(b) The application should contain the particulars of information sought.
(c) The evidence of payment of application fee should be enclosed.
(d) The address of the applicant should be available for sending a reply.
(b) The application should contain the particulars of information sought.
(c) The evidence of payment of application fee should be enclosed.
(d) The address of the applicant should be available for sending a reply.
Personal details except those necessary for contacting an applicant are neither required to be mentioned nor can be called for by the PIO.
Subscribe to:
Posts (Atom)
