Thursday

Fix Error 9002: Transaction Log Full For SQL Server

Fix Error 9002: Transaction Log Full For SQL Server
04:52 by andrew jackson

Overview of SQL Server Error 9002

Sometimes while working on SQL Server database we come across an error 9002. Which indicates that Transaction log for SQL Server is full. There may be several reasons through which the log file may become very large and run out of space or become full. Transaction log error 9002 generally occur when a log file is full or the disk space in which log file stored is full and cannot expand the log files further. In such circumstances, database remains online, but can only be read and no update operation can be performed. If this error occur while recovery then databases marked as resource pending.

Error 9002 msg:
The log file for database '%*Is' is full. Back up the transaction log for the database to free up some log space.
SQL Server database records all the transactions and the modifications done by each transaction. Transaction log must be regularly truncated to maintain the log space and keep it away from filling up. Some operations can be minimally logged to reduce their impact on transaction log size.
If the error 9002 occurred, when database was in recovery mode then after resolving problem ALTER DATABASE database_name SET ONLINE must be used.

How to Fix SQL Server Error 9002?

Following action can be performed for troubleshooting SQL Server transaction log full Error 9002:
  • Log backup can be done.
  • Log file can be moved to some other disk having sufficient space.
  • Log file size can be increased.
  • Freeing disk space so that the log file may grow automatically.
  • Long running transactions could be killed.
  • Adding a log file to other disk.
However, Transaction log is an essential part of database, which is required to return the database in consistent state if any system failure occurred. That’s why shrinking, deleting or moving transaction log be done after fully understanding the outcome of the action performed.
The above actions performed for troubleshooting t-sql error 9002 described below:

Transaction Log Backup

In case database uses the full or bulk-logged recovery model, and transaction log backup has not been done recently. Then there is need to take recent backup of the transaction log to free some space and supports restoring the database from a specific point. Log backup should be taken frequently to keep the log from filling up again.

Moving Log File to Another Disk

If creating enough space on the disk that containing the log file is not possible, then log file should be moved to some other disk having sufficient space. While moving log file one should never place the log file on a compressed file system. The log file can be moved by using concept of database detach and attach.
sp_detach_db executed to detach database.
sp_attach_db executed to attach database.

Increase Log File Size

As maximum size for log file is two terabytes(TB). So if space available on the disk log file size can be increased. Size can be increased manually to produce a single grow increment in case autogrow disable and a database is online. Also, we can enable autogrow by using ALTER DATABASE statement.

Freeing Disk Space

The disk containing the transaction log file can be freed by deleting or moving some files from that disk to another disk. Freeing the disk space will enlarge the log file automatically on that disc.

Add Log file to Another Disk

A new log file can be added to the database on the different disk by using ALTER DATABASE ADD LOG FILE.

Conclusion

We get to know about SQL Server Transaction Log Error 9002. Error 9002 in SQL Server occurred when the transaction log file is full. While moving or deleting a transaction log file the outcome of the action performed should be kept in mind. Several actions which can be performed to solve this error are discussed briefly.

Suggested Reading

MVC Areas: Organizing an Application using Areas

MVC Areas: Organizing an Application using Areas
08:25 by Anjan Kant

Introduction

MVC architecture is inherently separated into three separate layers like Model (database), Presentation (UI, View), and Controller (Business layer). Releasing of MVC 2 introduces new feature of Area which provide solid capability to further separate files of file structure. Using with Area, we can define same controller in different areas to make our application more modular, manageable and robust. In this demonstration, I have used two areas Main (Public website) and blog area. In my earlier article, how to stop cross-site request forgery. I am explaining all steps how to organizing an application using areas in MVC.
mvc area

Why We Need MVC Areas

When we need multiple departments to maintain with different controllers even having with the same name in different areas. It makes our application more manageable, easy and maintainable to make our development faster.

Create a New MVC Project

First of all, create a new fresh project of MVC

create new project mvc area

New Project Crated

New project created for playing MVC feature of Area.

new project created

Create a New Area

Let’s now start to create a new area. Right click on project then move to Add >>> Area then provide a new relevant name of area.
Create mvc area

Creating Blog Area

Here typing relevant new area name like “Blog”.
type blog area name

Blog Area Created

Now you can see new created area “Blog” under the project.
Area Blog Created

Blog Area File Registration

You can see a new file crated of Blog Area Registration (BlogAreaRegistration.cs) under blog area.

public override string AreaName
{
    get
    {
 return "Blog";
    }
}

public override void RegisterArea(AreaRegistrationContext context)
{
    context.MapRoute("Blog_default",
        "Blog/{controller}/{action}/{id}",
 new { action = "Index", id = UrlParameter.Optional }
    );
}

Area Registration in Global.asax

Area registration is also done in Global.asax file.
public class MvcApplication : System.Web.HttpApplication
{
    protected void Application_Start()
    {
    AreaRegistration.RegisterAllAreas();

        WebApiConfig.Register(GlobalConfiguration.Configuration);
    FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
        RouteConfig.RegisterRoutes(RouteTable.Routes);
    }
} 

Main Area Creation

Next one new main area is crating in this section.
Main blog area created
Area Registration File Created
In the same way, as in blog area a registration file (MainAreaRegistration.cs) is also created.

public class MainAreaRegistration : AreaRegistration
{
 public override string AreaName
        {
        get
        {
            return "Main";
        }
    }

public override void RegisterArea(AreaRegistrationContext context)
    {
        context.MapRoute(
            "Main_default",
            "Main/{controller}/{action}/{id}",
            new { action = "Index", id = UrlParameter.Optional }
        );
    }

Create Home Controller for Main Area

Creating home controller under main area.
Home controller for main area

Create Home Controller For Blog

Alike main area, Home controller is also creating under blog area. Area feature let allow us to create same controller name to make our development more lucrative.
Home controller for blog area

Create View for Both Home controllers of Main & Blog

Here is creating view for Blog and main area.

@{
ViewBag.Title = "Index";
}
<h2>Welcome to Blog Area</h2>
<div> @Html.ActionLink("Back to Main", "Index", "Home", new { area = "Main" }, new { }) </div>
 Main Area View
@{ ViewBag.Title = "Index"; }
<h2>Welcome to Main Area</h2>
<div>
    @Html.ActionLink("Go to Blog", "Index", "Home", new { area = "Blog" }, new { })
</div>

Set Default Area/Controller/Action

Here, you can set your default area, controller and method to launch your application (landing page of your application). Before to set, you need to right click on project and click on properties to navigate on Web tab to set application default page (Area/controller/action).

Area Default Page

or Alternatively can set in RouteConfig.cs

Routes.MapRoute(
                name: "Default",
                url: "{controller}/{action}/{id}",
                defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional },
                namespaces: new[] { "slnMvcArea.Areas.Main.Controllers" }
            ).DataTokens.Add("area","Main");

Now Run your MVC area application

Finally run your MVC app to see how works MVC area feature.

welcome to main area

Navigate to Blog Area

Click on “Go to Blog” to navigate blog area.

welcome to blog area
Now you are on blog area, here is also a link to navigate “Back to Main”.

Conclusion

MVC areas helps us to make more manageable our MVC application to further divides into different files. In each area, we can define same controller like Main area contain “Home” Controller then also other areas can contain same area name “Home”, this code will compile perfectly even we have same controller name in different areas. Thus, it will help us to make large volume of applications with multiple departments so that can build awesome MVC apps with area feature. I tried here to demonstrates all necessary steps to organize an application using areas in MVC app.

Video: This video also demonostrates about Organizing an Application using Areas.

Wednesday

How To Own ASP.Net MVC Page Life Cycle For Free

How To Own ASP.Net MVC Page Life Cycle For Free
08:36 by Anjan Kant

Introduction

Before to start over to know about MVC complete Life Cycle, it is mandatory to add required namespaces in web.config which are automatically added when we add MVC package in our MVC application. We all know the basic behaviour of MVC is based on HTTP requests. In my recent article, I have already explained how to create amazing charts using MVC.

I have provided all necessary MVC life cycle steps here.
<namespaces> 
<add namespace="System.Web.Helpers">
<add namespace="System.Web.Mvc">
<add namespace="System.Web.Mvc.Ajax">
<add namespace="System.Web.Mvc.Html">
<add namespace="System.Web.Optimization">
<add namespace="System.Web.Routing">
<add namespace="System.Web.WebPages">
</namespaces>

1) We send our request through HTTP to our server.
2) Then request goes through our MVC routing.
3) Our web request sends through Global.asax file where all routes are registered under this file, according to our MVC request then request is forwarded according to matching route.
ASP.Net MVC Page Life Cycle

protected void Application_Start()
{
    AreaRegistration.RegisterAllAreas();
    WebApiConfig.Register(GlobalConfiguration.Configuration);
    FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
    RouteConfig.RegisterRoutes(RouteTable.Routes);
    BundleConfig.RegisterBundles(BundleTable.Bundles);
    AuthConfig.RegisterAuth();
    //ModelBinders.Binders.DefaultBinder = new Microsoft.Web.Mvc.DataAnnotations.DataAnnotationsModelBinder();
    AreaRegistration.RegisterAllAreas();
}
4) Route is filled in Route.Config file where our controller, view and parameter (optional) are given to complete our request.

public static void RegisterRoutes(RouteCollection routes)
{
    routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
    routes.MapRoute(
    name: "Default",
        url: "{controller}/{action}/{id}",
        defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
    );
}
5) After filling the route through Route.config, now request is redirected to our controller.

  public ActionResult Index()
  {
   return View();
  }
6) At the end, Result is shown in a view of MVC controller attribute where all desired information is displayed over here.

@{ ViewBag.Title = "Home"; } 
<!DOCTYPE html> 
<html lang="en"> 
<head> <meta charset="utf-8" /> 
<title>@ViewBag.Title</title> 
<link href="~/favicon.ico" rel="shortcut icon" type="image/x-icon" /> 
<meta name="viewport" content="width=device-width" /> 
</head>
 <body> <div> Welcome to Technology Crowds </div> </body> 
</html>

Conclusion

In this article has shown how works MVC life cycle when we request through HTTP in our web browser. Requests, Routing, controller, view, MVC handler (Razor etc) are key components of MVC.

Suggested Reading

Monday

Fix SQL error: 26 - A network-related error occurred in SQL Server

Fix SQL error: 26 - A network-related error occurred in SQL Server
01:26 by Anjan Kant

Introduction

This article explains how to configure an instance of the SQL Server Database Engine to listen on a particular fixed port by utilizing the SQL Server Configuration Manager. The default example of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are arranged for dynamic ports. This implies they select an accessible port when the SQL Server administration is begun. When you are interfacing with a named instance through a firewall, setup the Database Engine to listen on a particular port, so that the fitting port can be opened in the firewall. Here are given 5 different approaches to get resolution of 26 - A network-related error occurred in SQL Server. In my earlier, I have already explained how to find and delete duplicate values in SQL server.

Error Description:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Approach 1: We can run this query to view your TCP endpoints 


SELECT name, protocol_desc, type_desc, state_desc, is_admin_endpoint, port, is_dynamic_port, ip_address FROM sys.tcp_endpoints

tcp endpoints

Approach 2: Here you can check which SQL port is running on your machine.


USE MASTER
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO

Approach 3: Run below command to check applications listening on ports, try this command on command line:


netstat -ap TCP

Approach 4:


i) Open Immediate Window (Windows + R) on your machine.
ii) Next type %windir%\System32\cliconfg.exe and click on Enter button.
iii) Now a new window will open, left side will show disabled port and right side will show enabled port.
disable tcp ip protocols

iv) Now Select TCP/IP disabled protocols and click on Enable button to add in enabled protocols list.

tcp ip properties

v) Now you will enabled TCP/IP protocols and click on properties, then finally you will see SQL Server port i.e. 1433



sql port 1433

Approach 5: 

  • Start from open your SQL Server Configuration Manager
  • Next click  on "SQL Server Network Configuration" and click on "Protocols for Name".
  • Now right click on TCP/IP, click on properties and make sure it is enabled.
  • Presently Select "IP Addresses" Tab - and-Go to the last passage "IP All".
  • Now enter SQL server port TCP/IP 1433
  • Remove 0 (keep totally blank) from TCP Dynamic Ports property
  • Now restart your SQL Server (Right click on SQL server Management Studio and click restart button).

Conclusion

Here are given 5 different approaches to resolve issue 26 - A network-related error occurred in SQL Server. Hopefully, these approaches would work to all who are looking to resolve issue 26 - A network-related error occurred in SQL Server.

Relevant Reading

SQL Server Schema Corruption Error 211: A Technical Solution

SQL Server Schema Corruption Error 211: A Technical Solution
23:59 by Daniel Jones

Introduction

The SQL Schema is a logical collection of SQL Objects including the tables, associated with columns, its relevant entries, or other elements. While creating the schema, a user will be able to access the database in more effective manner. However, a situation occurs in SQL server that different errors occurs while accessing it. One such error is SQL server error 211, which occurs when the server table is getting updated. In the following section, we will cover reasons for corruption in the server Schema and then possible solutions to overcome this error.

Problem Statement

Suppose a user tries to update some database tables on his server and meanwhile a schema corruption error message occurs on the system. This error can exist in any version of SQL Server such as Server 2005, 2008 etc.
“Msg: 211, Level 23, State 51, Line 1 Possible schema corruption.
Run DBCC CHECKCATALOG
Msg 0, Level 20, State 0, Line 0”

Reasons Behind SQL Server Error 211

Generally, schema corruption in database evolve very rarely in the SQL Server. When this error took place, a user have to check out the main cause of the error i.e., either via SQL error Log files or some other.
There are multiple reasons where schema gets corrupted and some of them are mentioned below:
  • Due to improper computer activities by server users
  • Sudden software failure leads to Schema corruption
  • Hardware failure is the major issue behind corruption

How to Fix Corruption Error 211 in SQL Server

There are several methods to resolve this server error. A user can choose any one approach to remove or delete the schema corruption which is present within the server. Following are the all possible solutions to fix the error:
  • One of the compatible solution for resolving this error is to restore the backup files of the database. In addition, go through following scenarios that will help you in restoring backup files:
    1. If a user has backup of transaction log, then take a backup of tail-log and restore the latest backup completely with entire transaction logs that are ending with tail-log backup. In such case, the result will become in 0 data loss.
    2. If a user does not have a backup of the transaction log then, develop a new database and import more data as possible or if a user is able to determine culprit table, then drop that table & recreate it.
  • The another approach is to repair entire MDF database file and then, you will have to deploy the database again.
  • The last manual trick is to execute DBCC CHECKCATALOG command on the server screen.
When you will run DBCC command the error will be displayed. Sometimes, much exceptions might occur while executing the Transact-SQL statement through SQL users with dedicated Schema. Make sure, a user will get the suitable suggestion from SQL server database by running DBCC CHECKCATALOG syntax. With the help of this command, users will get to know the location and reason behind the SQL server error 211. However, DBCC CHECKCATALOG signifies no error, but it is not possible at all time.

Alternate Solution to Resolve SQL Server Database Corruption

The most appropriate solution for fixing SQL error code 211 is third party SQL recovery tool. It is safe and secure way to troubleshoot this error with help of following steps:
Step1: Launch SQL Recovery, Add MDF file and press Open button

Step 2: Analyze all your data of the server file and then click on Export button

Step 3: Now, select an option between two i.e., with the only Schema or with Schema & Data for exporting MDF file and click on save to start migration process

Finally, you will be able to get a healthy MDF file with help of this solution and hence, fix SQL server error 211.

Conclusion

Here we are ending with one of the server error, which create hurdle while accessing the SQL Server database. The best possible solutions are also discussed to overcome this possible Corruption Schema error. Well, it is recommended to first restore the backup file of server, if a user is having it. Else, you can go for other solution for resolving SQL server schema corruption error 211.

Suggested Reading

Product Review of Kernel for SQL Server

Product Review of Kernel for SQL Server
03:23 by Ashish Srivastava

SQL Server is the well-developed Microsoft entity which provides flexible and correlational data management services to the organizations. Also referred sometimes as MS SQL and Microsoft SQL Server, The SQL Server is basically a set of relational database management service which extensively supports ANSI SQL, which is a standard server language. The SQL server also contains T-SQL, which is its own SQL implementation. Microsoft offers SQL server in different editions with different features and outcomes.
  • Enterprise Edition: Being the most expensive among SQL Servers, the Enterprise edition is meant for large organizations that deal in bulk volume of data every second.
  • Standard Edition: Perfectly designed to act as support for small and medium scale enterprises. It is prefect for medium level data volume.
  • Workgroup Edition: Perfect for startups and very small scale business groups. It is perfectly used for backend database for small webservers.
  • Express Edition: It is a free edition that is meant for distribution as it has limited number of features to be used. This edition is often referred to replace the Access database.
The availability of different editions of SQL Server is not so difficult, but the most common observation in every edition of SQL Server is issues with MDF and LDF files. The entire database of SQL server is saved in Master copy called MDF files. The MDF database files are the primary database file which entails schema and data. The other file format is LDF that maintains Log files. Due to some reasons the MDF files getcorrupt. To fix these MDF files it is important to take required action through some reliable source like Kernel for SQL Server.

Necessity of External Assistance

Kernel for SQL Server is an external agency designed to fix the MDF files that got corrupt due to technical complications. This SQL Server tool is perfect to fix the most notorious SQL-related issues. It includes:
  • MSDTC configuration issues.
  • Non-existent Disaster Recovery Plan.
  • Weak SQL login password.
  • TEMPDB pagelatch contention.
  • System Memory issues.
  • Usage of NOLOCK.
  • Non-scheduled Database Integrity checks.
From being a perfect tool to fix the SQL related issues to being a tool for maintaining the SQL Server, Kernel for SQL Server effectively manages every task assigned to it in a very simple manner. The entire credit goes to the inbuilt algorithm that drives the entire process.

An Intro to Kernel for SQL Server

Designed to fix the MDF file corruption with Auto SQL Version Detection Feature, Kernel for SQL Server haunts the SQL – related issues every time. The QFSCI algorithm takes care of the entire process with a great care for MDF file components. To experience the real functioning of Kernel for SQL Server the evaluation version can be downloaded that works exactly like the licensed version with a limitation of not restoring the recovered MDF files. The performance of this celebrity tool also depends upon the system configuration and supported versions. To eliminate any chance of incompatibility, the tool supports all versions of MS SQL Server, Windows OS and Windows Server. Moreover, prior downloading the evaluation version of the tool, it must be known to the user that the tool perfectly works in the system that comprises Pentium class processor with minimum 64 MB RAM and enough disk space to save results.

What is so special about Kernel for SQL Server?

Ardent features, which were once the dream of SQL Server users are now the reality and that too in the platform which can be easily managed. With user-friendly graphic interface no special training is required nor is any technical background needed. The only thing expected from the user is knowledge of the location of the MDB files and a rough estimate about the SQL repair tool’s working.
The specialty of Kernel for SQL Server lies in its features. These features play significant role in recovering the damaged MDB files:
  • Reveals the SQL Server version automatically.
  • Effective recovery of MDF files.
  • Essentially restores MDF file components like Tables, Index, keys and much more.
  • Dual Saving modes to save the MDF files differently.
  • Provides ‘Preview’ option to view the recovered items to ensure correctness.
  • Maintains data integrity throughout the process.
  • Independent of MDF file size limit.
  • Recovery of multiple MDF files in a single repair cycle.
To explore more about the tool it is suggested to download the trial version of the tool that works alike licensed version with a limitation of not saving the recovered MDF files.

Expanding Every Valuable Feature

  1. Witty Selection of MDF Files: Kernel for SQL Server makes quick selection of MDF files required to be recovered. To make this happen, the user-friendly GUI of the tool is available which can be independently tackled by any naïve user. To initiate it, user has to launch the SQL Recovery software followed by selecting the concerned MDF files. Once it is done the tool is ready to go.

Select Database to Recover

  1. Automatic Selection of SQL Server Version: To know the version of affected MDB files normally user applies conventional techniques but owing to the new technology that is used by external tool it has become very easy to find it out. To make this happen user has to select the concerned EDB file, upload it and tick the box that reads ‘Auto Detect Database Version’. On selection of this feature, your workload remains half and rest is performed by the third-party tool.

    Select SQL Database

  1. Stunning Recovery: The MDB files subjected to recovery are perfectly loaded by the user. With this action the manual support for the tool ends here. Now, following the remaining steps, everything is automated and just needs manual clicks to keep the process on going. On recovery of concerned MDF files, the user’s screen appears as like
Stunning Recovery

  1. Schematic Representation of Recovered Items: SQL Recovery Tool delivers B-tree structure of the recovered MDF file components. The schematic representation of the recovered items clearly makes the way for the user to select the specific file to ensure the correctness in the recovery process. User has to just select the object from the tree prior saving. When selection is made, the requisite content will be displayed on the right pane of the Window.
Schematic Representation of Recovered

  1. Save what is recovered: Post deciding that recovery is perfect, now is the time to get introduced to the stunning saving option. The saving mode gives a choice of saving the recovered files directly to SQL Server or simply to the Batch File.

Saving Mode

  1. Knowing the Performance Capacity: The Performance capacity of Kernel for SQL Server can be witnessed without spending a money or clicking the dialog box for online annual subscription. User has to simply download the evaluation version of the SQL Server recovery tool that has some limited potential to recover the damaged MDF files up to some extent. However, user cannot save any recovered files with it. To do so, the licensed version has to be purchased that facilitates limitless recovery irrespective of the SQL Server version.
  2. Speedy Delivery of License Key: Kernel for SQL Server is known for its outstanding performance. If user is satisfied with the tool’s performance in the evaluation version and is willing to purchase the licensed version of the same, then it can be done by using any of the different payment options like PayPal, Credit/Debit, E-Cheque and Pay Order. Once payment is received, the key of the licensed version is sent through the email to the user. In totality, it merely takes few minutes to procure the license key of the tool.
  3. Round-the-Clock Technical Support: The software is ardent in maintaining the client relationship. It is made possible by allowing technical support to the client whenever needed. Every ticket raised by the user is important for us and it is dealt with a great concern. After providing the required solution, it is conformed if user is facing any issues. The technical follow-up is kept to trace the history of the query that made the client concerned. To gain the online help related to SQL database recovery tool, user can simply log on to https://www.kerneldatarecovery.com/sql-recovery.html

Kernel for SQL Server Provides a Common Stage

Kernel for SQL Server is a center-stage to different versions of MS SQL and other required applications. The single stop solution for affected SQL files is responsible for fixing the SQL database irrespective of the version of its origin. To materialize the claimed capacity, the tool supports all versions of the required programs. This also eliminates all chances of incompatibility issues.
Supported Versions
  • MS SQL Server 2014/2012/2008 R2/2008/2005
  • Windows 10/8.1/8/7/Vista/XP/2000/98/NT/95
  • Windows Server 2012/2008 R2/2008/2003 R2/2003
Where Kernel for SQL Server fits the best?
The SQL Server Recovery tool graciously performs well in the system that comprises:
  • Pentium Processor
  • Minimum 64 MB RAM
  • 50 MB Space for Software Installation, and
  • Some space to save results.
The tool’s performance also depends upon the system configuration; therefore, prior downloading any version of the tool, it is recommended to check the system requirements.

Wednesday

How to find and delete duplicate values in sql server

How to find and delete duplicate values in sql server
08:05 by Anjan Kant

Introduction

Today, I am writing about how to Find and delete duplicate values in SQL server and delete in our SQL Server database, sometimes data is inconsistent due to not proper relational integrity it results to duplicate rows in corresponding tables. Duplicate records of any database will lead to unstable application and it will not generate information according to end user expectation. I have clarified extremely known SQL Server error SQL Server Error 25 And 87.
SQL duplicate records

Monday

Software Review - Stellar Phoenix SQL Database Repair

Software Review - Stellar Phoenix SQL Database Repair
23:00 by Priyanka Chouhan

While the database is in Suspect mode, no transactions are possible till it gets repaired. There can be a number of reasons due to which SQL database is marked as SUSPECT. These reasons include faulty hardware components, inappropriate shutdown, missing transaction log, malware attack, corruption in transaction log file, application crash and much more.

I came through the same situation where SQL Database turned to the SUSPECT mode. Analyzing the error log helped me to detect the actual reason behind the cause. This sometimes helps to bring the database to the online mode efficiently. To resolve this issue, initially, it requires changing the status of the database to EMERGENCY mode to gain read-only access as a DBA.

After doing this, I tried executing DBCC CHECKDB for executing logical and physical integrity checks. Further, repair_rebuild and repair_allow_data_loss were executed for SQL repair operation. However, during the initial attempt to gain access to the database tables, I realized that some content is missing.

Probability: Executing DBCC_CHECKDB with repair_allow_data_loss might have resulted in loss of data components and, sometime DECC CHECKDB with REPAIR_ALLOW_DATA_LOSS is not working.

Read here the complete article on this problem: http://www.stellarinfo.com/blog/dbcc-chekcdb-repair-allow-data-loss-not-working/

Since no recent backup is available, all deleted records need to be recovered. Then I decided to deploy Stellar Phoenix SQL Database Repair tool with the hope to get data recovered. The tool is known to integrate the following features:

     1. Repairs damaged MDF and NDF database files
     2. Recovers deleted records
     3. Recovers SQL tables, queries, rules, indexes, keys, defaults and triggers
     4. Recovers selective data from the selected database file
     5. Saves recovered files as HTML, MS SQL, CSV and XLS file formats
     6. Supports SQL Server 2016\ 2014\ 2012\ 2008 and lower versions

What does SQL Database Repair Tool Offer?

Since database encounters data loss after being recovered from the SUSPECT mode, the MS SQL database repair software was initiated for repairing the corrupt data. The performance of the tool is quite surprising as it recovered maximum contents from the inaccessible database files. Initially, the recovered contents get displayed within the tool panel.

Listed below is the complete functionality of the tool:


     1. Download, install and launch Stellar Phoenix SQL Database Repair. The tool will instruct to stop the SQL Server and copy the corrupted database to another location. This is quite practical because database connected to MS SQL Server cannot be modified as it is under the control of the Server.

Select Corrupt MDF file


     2. Click on Select Database button to upload the damaged database file: During MS SQL 2016 repair procedure, the tool provides the option to select the drive on system with the file type (i.e. MDF or NDF) and search database in that particular location. Alternatively, click on Find button if the location of the file is unknown.

     3. Select the checkbox that says “Include Deleted Records” to recover deleted data from database

     4. Click on Repair button to start the repairing procedure

     5. Select a particular component or folder from the left pane of the tool to preview the integrated items.Once the corrupt database file is selected, the tool enlists all the items saved into that particular file in the right panel of the tool
Preview of repaired data

     6. A message will be displayed that indicates “Selected MS SQL database repaired successfully”. Click on OK to save the repaired data
     7. The tool provides different options to save the repaired data that includes MS SQL, CSV, HTML and XLS
Save Repaired SQL Database

Note: The tool also provides the option to save repaired database file at a selected location on the machine. You can select destination path by clicking on the Browse button. By selecting the given checkbox, you can instruct the tool to automatically open the destination folder once the repaired file is saved.

     8. Then, click on the OK button
     9. Next, the tool offers to save the repaired data either in the New Database or Live Database

Note: You also need to provide Server credentials while saving repaired data to the SQL Server. Next, the tool will prompt you to enter the Server instance name, Authentication, and the name of Existing database. 

     10. The tool will display a message “File saved at the desired path.” Click on OK to complete the procedure
SQL Repair Versions and Purchase Information

SQL Database Repair tool offers two different versions that include: 

     - Trial edition
     - Licensed edition

The trial version of the software offers restricted access. With this version, you can test the functionality up to Step 6 mentioned in the above procedure. This version allows accessing the preview of the repaired data within the tool panel. However, the repaired data can be saved after purchasing the licensed version of the tool. 

To buy the licensed version of the tool, click on the Purchase icon available in the Help menu on the Menu Bar. Next, select the appropriate option for purchasing the software and select a payment mode. Once the payment is processed, the Serial Key will be sent to the registered email id. You can then activate the tool by using this Serial Key. 

Final Verdict
As per my experience, the functionality of Stellar Phoenix SQL Database Repair tool is accurate and efficient when tested on MS SQL 2016 database. During MS SQL 2016 repair process, the tool repaired entire data components that have become inaccessible after the database is brought online from Suspect mode. The integral contents and attributes of the tables, triggers, rules, indexes and other components remain intact, and the integrity of the database is not compromised. 

Saturday

CSRF: Prevent Cross-Site Request Forgery using AntiForgeryToken() in MVC

CSRF: Prevent Cross-Site Request Forgery using AntiForgeryToken() in MVC
00:43 by Anjan Kant

Introduction

At whatever point we chip away at our application we constrained to our undertaking extension and its business rationales to accomplish our task time conveyance. We couldn't concentrate such a great amount to our security reasons and later after sending of our venture is hacked through cross-site demand imitation. .Net Framework has introduced a new security feature to protect our MVC projects data using anti forgery token whenever we submit data through our MVC application data. Cross-site scripting (XSS) is most dangerous issue on web (internet application). I have already explained a MVC very known error Unexpected if keyword after @ character.
Prevent Cross-Site Request Forgery using AntiForgeryToken() in MVC

Monday

SQL Backup Repair Tool to Recover Corrupt BAK File (Review)

SQL Backup Repair Tool to Recover Corrupt BAK File (Review)
00:20 by Daniel Jones

SQL Server is a relational database management system designed with the aim to store and retrieve data. Users can back up the SQL database in a backup file named as BAK file. This file enables the users to recover the entire SQL database in case of any damage to the database. However, the real problem arises when the BAK file gets corrupted or damaged due to certain issues. Thus, in this case it becomes necessary to recover corrupted BAK file. Now the question comes how to recover corrupt BAK file? One such solution to recover the BAK file is by using the third party utility, i.e. SQL Backup Repair Tool. This review discusses about the same based on the performed software testing.

Introduction

SQL backup repair tool is designed in such a way that it helps to recover and export the .bak file into SQL server. The application maintains the integrity of data after recovery. It recovers unlimited amount of data within few moments. It can be accessible on all Windows Operating system.

Quick View

Functions Recovers the SQL Backup File
Current version 5.2
Size 6.3 MB
Interface Graphical User Interface
Windows version supported 8.1 and below editions
Price $149

Different Editions of SQL Backup Repair Tool

The tool is available in two versions, i.e. Demo and Licensed. Users can choose any version accordingly.

  • Demo Edition
Before going for the license version, it is advised to check the working of the tool with the help of the trial edition. The trial version is available free of cost and can be downloaded from the official website. However, there are some limitations, i.e. it scans, and shows preview the entire recovered .bak file but cannot store and export them.





  • Licensed Edition

  • Once the user is satisfied with the working of the demo version, the license version of the tool can be purchased from the official website. It permits users to retrieve, store, and export them into Database of SQL Server.

    Essential Features

    • Recover Complete Backup File
    • SQL backup repair tool enables the user to recover the entire data stored in the backup file like rules, triggers, tables, stored procedures, etc. The users can view the entire data before exporting the data from the file.
      Recover Complete Backup File
    • Export Data With Schema
    • The application offers two options to save the recovered data from the SQL BAK file. The user can save only Schema or can save both Schema and Data. Both the options ensure maintaining the original structure intact.
      Export Data With Schema
    • Dual Export Options
    • The users can export the recovered data directly in SQL server database or can store it in SQL server compatible scripts. The SQL script file can be later restored in SQL server accordingly.
      Dual Export Options
    • Selective Data Export
    • SQL backup repair tool allows the users to recover corrupt SQL BAK file and export selective data from SQL BAK file. The user can selectively export only the necessary data items from the SQL backup file.
      Selective Data Export
    • Supports Both Keys
    • The software provides extended support for all the elements of the database along with primary and foreign keys. The application is programmed in such a way that supports both the keys while retrieving the database.

    • Preview Data Component
    • Once the corrupt SQL backup file is recovered by the application, it allows the users to preview the data. The preview of complete data contains the tables, rules, triggers, functions, columns, Indexes, views, etc.
      Preview Data Component

    Pros:
    • Supports all editions of Windows
    • No file size limitation

    Cons:
    • Fails to back up the deleted files
    • Does not supports Mac OS.

    Conclusion

    Considering the working performance of the SQL backup repair tool, it can be rated as 9.5/10. Although, the application fails to recover the deleted files and does not support Mac operating system. However, it efficiently recovers the highly inaccessible files. Moreover, its in-built and user-friendly interface is very helpful for users to repair corrupt SQL backup file. It supports dual mode to export the recovered data.

    Suggested Reading

    Saturday

    Text to Speech: Download free Text to Speech Software

    Text to Speech: Download free Text to Speech Software
    00:24 by Anjan Kant

    Introduction

    Free Text to Speech software is empowered with rich functionality to read any text format into speech/voice.

    Free Text to Speech Software Version (1.8.0.0)

    Most Popular Supporting Windows Environment

    Windows 10

    • Windows 10 Home
    • Windows 10 Pro
    • Windows 10 Enterprise
    • Windows 10 Enterprise LTSB
    • Windows 10 Education

    Windows 8

    • Windows 8.1
    • Windows 8.1 Pro
    • Windows 8.1 Enterprise
    • Windows 8
    • Windows 8 Pro
    • Windows 8 Enterprise
    • Windows 8 OEM

    Windows 7

    • Windows 7 Home Basic
    • Windows 7 Home Premium
    • Windows 7 Professional
    • Windows 7 Enterprise
    • Windows 7 Ultimate
    • Windows Thin PC
    • Windows Vista Home Basic
    • Windows Vista Home Premium
    • Windows Vista Business
    • Windows Vista Enterprise
    • Windows Vista Ultimate

    Windows XP

    Text to Speech/Voice Supporting Languages

    • English
    • Spanish
    • French and other European languages.

    System Requirements

    This is light weight programming it will keep running at any PC with least prerequisites with taking after segments Processor, RAM, Hard Drive Space, Graphics card, Sound Card, PC Speakers, Display and so forth.

    Feedback

    Your input is essential for me with the goal that continue sending your profitable criticism to include new usefulness in this product. In not so distant future, you will see more usefulness in this product.
    Download Free Text to Speech

    Dependency

    Download Free Microsoft .NET Framework 4.5 if not already installed on your computer.

    Pros


    • It is very lightweight software.
    • It consumes very little storage of your computer.
    • It is one click software to install on your computer.

    Cons


    • It covers only Windows Operating system.

    Steps to Install Free Text to Speech Software

    Step #1: First of all download Setup from given link here and end of the article. Now unzip folder and start setup  on click Setup_Speech_Text
    text to speech setup file

    Step #2: Now you can see progress installing your free text to speech software.
    text to speech installing progress

    Step #3: Once finished installing process. Finally hit Finish button to complete your installation process.
    install text to speech finish

    Step #4: Now check your Windows desktop icon where your fee text to speech software already installed.
    text to speech desktop icons in windows 10

    Step #5: From very left, click on first icon, a new window will open where you can write or copy/paste text to read from text to voice. Finally click on Read Now button to start reading your text.
    text to speech read now button

    Step #6: Next icon will open a new window where you can send your suggestions to make this software more powerful.
    text to speech suggestions box

    Step #7: Last icon will open this software basic information.
    text to speech info software


    Download Free Text to Speech Software
    Download

    Suggested Reading

    .Net OOPS: OOPS interview questions

    .Net OOPS: OOPS interview questions
    00:51 by Anjan Kant

    Introduction (OOPS)

    OOPS Programming allows us to develop smaller to smaller logical modules, later we can integrate into one form of software. OOPS includes classes under that methods, entities, events, properties, modules etc. By creating objects can access data in OOPS programming. .Net framework supports only OOPS languages such as vb.net, c#, asp.net, C++ etc. In my earlier example, I have covered almost all MVC ASP.Net Interview Questions And Answers.

    1) What is class in .Net OOPS Programming?

    Access modifiers allows us to access its class members in different types like Public, Private, Protected, Internal, Protected internal, Static.
    Class Inheritance allow us to do to access its base class information and behaviour. Colon image permits us to inherit its base class from derive class.
    public class Furniture
        {
            //Fields, properties, methods, members, events, constructors, destructors etc.
        }
    

    2) What is Class and Class Inheritance in OOPS Programming?

    public class Furniture
        {
            //Fields, properties, methods, members, events, constructors, destructors etc.
        }
     Public class Sandal:Furniture
        {
            //Fields, properties, methods, members, events, constructors, destructors etc.
        }
    

    3) What are objects in OOPS?

    Objects are like variable those who enable to encapsulate data and behaviour
    Furniture _obj = new Furniture();

    4) What are the basic concepts of OOPS ?

    Main top four main features of OOPS are as follows:
    I) Abstraction:- In .net framework, abstraction enable to use multiple inheritance, with the access of abstraction can hide important data and show only important data to show user.
    II) Polymorphism: It capable to use one form into multiple forms.
    II) Encapsulation: We can say encapsulation is subset of abstraction. We can restrict user to show data with the use of encapsulation.
    IV) Inheritance: While we are using inheritance there are two main parts one is derived class and other one is base class. Inheritance provides to capable our application to reuse our code and reduce code size.
    oops main components
    OOPS main components

    5). Which of the following type of class allows only one object of it to be created?

    • Virtual class
    • Abstract class
    • Singleton class
    • Friend class

    6). Which of the following statements is correct?

    • Base class pointer cannot point to derived class.
    • Derived class pointer cannot point to base class.
    • Pointer to derived class cannot be created.
    • Pointer to base class cannot be created.

    7). Which of the following is not the member of class?

    • Static function
    • Friend function
    • Const function
    • Virtual function

    8). Which of the following concepts means determining at run time what method to invoke?

    • Data hiding
    • Dynamic Typing
    • Dynamic binding
    • Dynamic loading

    9). Which of the class’s instances themselves are classes?

    • Subclass
    • Abstarct Class
    • Metaclass
    • Object Class

    10). Which of the following concept of oops allows compiler to insert arguments in a function call if it is not specified?

    • Call by value
    • Call by reference
    • Default arguments
    • Call by pointer

    11). Which of the following cannot be friend?

    • Function
    • Class
    • Object
    • Operator function

    12). Which of the following concepts of OOPS means exposing only necessary information to client?

    • Encapsulation
    • Abstraction
    • Data hiding
    • Data binding

    13). Why reference is not same as a pointer?

    • A reference can never be null.
    • A reference once established cannot be changed.
    • Reference doesn't need an explicit dereferencing mechanism.
    • All of the above.

    14) Initialise var to null in C# ?

    • var _myVal = (dynamic)null; 
    • var _myVal = (int32)null; 
    • var _myVal = (int)null; 
    • var _myVal = (string)null; 
    • None;

    15) What is Mutable string in .Net framework OOPS? 

    • A mutable string state can't be change 
    • A mutable string state can be change 
    • None 

    16) What is Immutable string in .Net framework OOPS?

    • A Immutable string state can't be change 
    • A Immutable string state can be change
    • None
    Read More: Difference between mutable and immutable string in .Net framework

    17) What is boxing ?

    • Object to value 
    • Value to object 
    • Both A and B 
    • None
    int a = 123;
    object o = a;  //boxing
    

    18) What is unboxing ? 

    • Object to value 
    • Value to object 
    • Both A and B 
    • None
    o = 123;
    a = (int)o;  // unboxing
    
    Read More: What is Boxing and Unboxing in .Net Framework

    19) Which modifier is used to class as a sealed class? 

    • Protected 
    • Private 
    • Sealed 
    • None 

    20) A sealed class cannot be used as a base class? 

    • Yes 
    • No 
    • None 

    21) Can be use sealed class as an abstract class? 

    • Yes 
    • No 
    • None 

    22) Can be use sealed class for inheritance?

    • No 
    • Yes 
    • None 

    23) Can be structs considered like sealed class? 

    • No 
    • Yes 
    • None
    public sealed class Csharp
    {
        // Class members here.
    }

    24) Can we instantiate Interface class ? 

    • Interface can be instantiated 
    • Interface cannot be instantiated 
    • Both A and B 
    • None 

    25) Does Interface class require inheriting ?

    • No 
    • Yes 
    • None 

    26) Which keyword is used to class as a sealed class?

    • Protected 
    • Private 
    • Sealed 
    • None 

     27) Does Interface class support inheriting?

    • Yes 
    • No 
    • None 

    28) Can Interfaces contain only the declaration of the members?

    • Yes 
    • No 
    • None 

    29) Which keyword is required to make Interface class?

    • Keyword
    • Sealed 
    • Interface
    • None

    30) Interface class can contains only properties, indexers, methods, delegates and events signature?

    • No 
    • Yes 
    • None 

    31) Can we instantiate abstract class?

    • No 
    • Yes 
    • None 

    32) Can be an abstract class as a sealed class?

    • No
    • Yes
    • None

    33) Can be an abstract class inherited from more than one class?

    • No 
    • Yes 
    • None 

    34) An abstract class can contain constructors and destructor?

    • No 
    • Yes 
    • None 

    35) Can it an abstract method likely implicitly virtual method?

    • No 
    • Yes 
    • None

    Conclusion (OOPS)

    OOPS provides great capability with Re-usability, Inheritance, Data Hiding, Reduced complexity of a problem, Easy to Maintain and Upgrade, Modifiable and Message Passing to develop high quality software with cost cutting.

    OOPS, IIS and Other ASP.Net Interview Questions and Answers: