Monday, November 17, 2014

Recover Suspected SQL Databases in SQL 2005/2008

SQL Database Suspect Issues and Solution

Some time databases may be suspect due to insufficient space or HDD issues in SQL 2005/2008. we can recover those suspected databases from SQL 2005/2008 using below queries.

Execute Below queries one by one using Query Analyzer

Step 1

Stop and restart the instance of SQL Server using 
EXEC sp_resetstatus 'myDB';

Step 2 

EMERGENCY mode is not SINGLE_USER mode. A database needs to be in SINGLE_USER mode for repair to run and EMERGENCY mode allows multiple connections from members of the sysadmin role. 
ALTER DATABASE myDB SET EMERGENCY

Step 3

Note that the usual error log entry from running DBCC CHECKDB is preceded by ‘EMERGENCY MODE‘ this time.
DBCC checkdb('myDB')

Step 4

Alter Database with single user using below query
ALTER DATABASE myDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Step 5

Repair Database using

 DBCC CheckDB ('myDB', REPAIR_ALLOW_DATA_LOSS)

Step 6

 Alter database for Multiuser

ALTER DATABASE myDB SET MULTI_USER
Change myDB as your Suspected database Name.

Recover Query for Pincode Database Suspected : Example

EXEC sp_resetstatus 'pincode';
ALTER DATABASE pincode SET EMERGENCY
DBCC checkdb('pincode')
ALTER DATABASE pincode SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('pincode', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE pincode SET MULTI_USER

Tool for Generate Report of Speed Post Incentive Bill Revised

Speed Post Incentive Bill generation Tool


Report Print Error Fixed

Procedure to Generate Report

  • Download SpeedIncentiveGen.exe Tool from PoTools.
  • Give Start and End transaction date then click on Generate Report.
  • Click on Print Button to print the Report.

Download


Size: 64kb
Download Link : Google Drive upload on 11.11.2014 12:30AM
Version and Developed : v1.0 and Developed by Admin, PoTools

CBS : Finacle Desktop Settings for Simple Restore

Finacle Desktop Settings

  • Download compressed file. 
  • Extract and double click on Restore Finacle Desktop Settings.exe to restore.
  • This will work in Windows7 / Windows XP/ Windows Server 2003 and Windows Server 2008.

Download Finacle Settings


Download
Thanks to Rajesh