Software Review – Stellar Phoenix SQL Database Repair

In this fast-evolving Digital Environment, Corruption is the most common occurrence. It mutely strikes at any instant and takes a toll on transaction, performance, and database availability. The reason for the SQL database SUSPECT condition can be anything including Application Crash, Improper Shutdown to the Missing Transaction Log. This action is potential enough to thwart the production badly.

Therefore, to counterbalance its impact and repair affected SQL Database, precise Recovery is the dire need. The best approach to cater to this request is by employing a Repair tool that combats the corruption and repairs the Database efficiently.

Thinking to buy a reliable Repair tool? Jumbled in the tons of options? Wondering which option is right for you? Here, Stellar Phoenix SQL Database Repair would serve the purpose. It has been self-evaluated, experimented, and approved. This fast and powerful tool is also the first and foremost choice for several professionals.

Stellar Phoenix SQL Database Repair: Transparent Analysis

Product Details

Product Name: Stellar Phoenix SQL Database Repair
Version: 8.0
Type: Do-it-yourself
Language Support: English
Limitations: NA

Minimum System Requirement:

Processor: Pentium Class
Operating System: Windows 10, 8, 7, Vista, XP and Windows Server 2008, 2003
Memory: At least 1 GB
Hard Disk: Minimum of 50 MB
Version Support: MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2008*64, 2008 Express, 2005, 2005*64, Express, 2000, 2000*64, 7.0 and mixed formats

Software Versions:

Demo Version

Intended for evaluation purpose
Enables to view only MDF files preview

License Version

Facilitates saving
Permits you to take advantage of all features

Brief Outline

An impressive do-it-yourself SQL Recovery software intended to fight back almost all SQL Server database damage or corruption scenarios including unexpected system shutdown, virus attack, to media read error. Further, recovers inaccessible MS SQL Server database files—MDF and NDF.

Backed by powerful non-destructive repair algorithms, this dedicated solution promises 100% database integrity assurance during repairing as well as recovering. With hands on this tool, you can safely recover tables, rules, indexes, triggers, keys, and defaults. The best thing about this software is its ability to recover even heavily damaged files seamlessly.

Key Features:

Supports recovery for deleted records
Capability to store repaired database to the Live database
Capability to save repaired database into CSV, HTML, and XLS format

Prominent Features:

Fast scanning algorithms
Facilitates Recoverable Database Objects Preview
Aids Object Name Search in tree view
Facilitates creation of Sorted tables in tree view
Prepare distinct log report after scanning database
Facilitates auto new database recreation
Option to save the scanned result automatically

Support Options

SQL Server Large MDF and NDF files
MS SQL Server Sequence Objects
Standard Compression Scheme for Unicode
MS SQL Server ROW Compressed data
MS SQL Server PAGE Compressed data
XML data types, XML indexes
SQL Server File stream data types, sparse columns, columns set property

Recovery Options

Column Row GUID COL Property
Defaults and Default constraints
Sp_addextended Property
Stored Procedure, Synonyms, and Functions
Tables, Identity Triggers, Indexes, Collations, and Views
Predefined defaults, default values, and Rules
Primary, Foreign, and Unique Keys
Check constraints, Null / Not Null, and User Defined Data Types

Positive Traits

Secure
Reliable
Easy to use
Straightforward
Simple user-interface
Ensures Data Integrity

ROW and PAGE Compressed Data Recovery Is In frame

The most distinguish feature of this software is its ability to recover SQL tables with PAGE and ROW compression. It is a much-demanded need by many users. In addition, it offers support for SQL Server 2008 R2 SCSU.

Powerful Algorithms to Safeguard Data Integrity

Thanks to its powerful algorithms, the top-most concern for every individual—Data Integrity is always maintained. This software comprehensively scans MDF files and efficiently recover as much data as possible

Deleted Record Recovery Is No More Hassle

This software enables you to recover corrupt database deleted records effortlessly without any alteration in original hierarchy. After recovery, you can easily save them in the newly created table.

Multiple Saving Options for Added Convenience

This powerful software has programmed to offer as much ease as much possible. Thereby, to provide utmost comfort, it comes with multiple saving options. You can choose the desired option to save the repaired SQL Server database. The hidden secret of this feature is that you do not require SQL Server on your system to access the file.

All Database Components Recovery Is In Frame

Another efficient feature speaking of its diverse nature. It lets you recover almost everything including column set property, Keys, Rules, and Indexes, to Stored Procedures in a hassle-free manner.

Selective Recovery is No More Tedious Task

With hands on this software, you can effortlessly perform selective database objects recovery. It allows you to choose desired database objects for recovery and save them at a specific location.

Disruption Is No more a Hindrance

Another quite significant feature of this software is its reconnection ability to Server automatically, in the case of interruption while repairing. Thanks to this feature, you can repair smoothly.

How does it Work?

The functionality of this software is very simple and straightforward. Simply follow the stepped instructions.

Steps to Repair and Recover are as follows:

Download, install and launch Stellar Phoenix SQL Database Repair software using the activation key
Click Select Database -> Select the database for recovery (In case, you are unaware of the exact destination, Click Find Database ->Folder -> Search)

Click Repair
All repaired database objects will enlist in the left pane
Click desired object to preview its data in right-pane

Now, save the repaired database. Click on the Save button
You have 4 options to save the repaired database

Here, I am choosing MSSQL option

You can see New database and Live database I selected the New database option and save the repaired database. Click Browse and state destination detail
On connection, click Connect
On generation of File saved at the desired path dialog box, click OK

The Repaired and Repaired process is complete.

Final Verdict

Every Database users’ searches for a recovery tool on which they can ultimately rely for resolving their both day-to-day and severe database corruption issues effortlessly. However, this smart software: Stellar Phoenix SQL Database Recover has all the unique traits to work efficiently in almost all corruption cases. Moreover, it is an edge over other humble competitors in terms of ease-of-use, scanning performance, flexible options, technical support and much more. Personally, my rating for this software is 9 out of 10. Try it!

How to add new instance in SQL Server

All program -> SQL Server Installation center
In windows 8 -> Search -> SQL Server Installation Cepter
From left menu select “Installation->New Sql server standalone installation or add features”
Browse CD or Physical directory of SQL Server
Auto run “Setup support rules” click ok
Product update -> click next
Install setup files -> click next
Setup support rules and click next
Select Installation type -> select “Perform new installation of SQL Server 2012” and click next
Enter product key and click next
I accept the licence key
Setup rules -> select “All features with default” -> Click next
Feature selection -> Click Next
Instance Configuration -> Named instance -> Type SQLExpress
And InstanceId -> Type SQLEXPRESS and click next
Server configuration -> click next
Database engine configuration -> Select windows authentication mode -> Click add current user and click next
Click next …. Next … next like as usual sql server installation.
After complete installation. Try to enter using new created instance

SQL Join with Microsoft SQL Server

What is SQL Joins?

A SQL join clause is used to combine records from two or more tables in a database based on common field between them. It creates a set of rows in a temporary table.

There are different types of joins available in SQL:
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• SELF JOIN
• CARTESIAN JOIN/CROSS JOIN

To understand JOINs, let’s consider the following two tables Customers and Orders is as follows

Customers

Orders

INNER JOIN
INNER JOIN returns match data between tables. It returns rows when there is at least one match in both the tables.

Syntax:

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
INNER JOIN Orders ord
ON Cust.Id = ord.CustomerId;

Output:

Id Name Amount Date

———– ————————————————– ————————————— ———-

2 Hamidur Rahman 4000.00 2014-01-10

2 Hamidur Rahman 5000.00 2014-01-10

3 Jamilur Rahman 3000.00 2014-02-13

4 Hasan Sarwar 600.00 2014-03-22

LEFT JOIN/LEFT OUTER JOIN
Left Outer Join returns all the rows from the left table in conjunction with the matching rows from the right table. If there are no columns matching in the right table, it returns NULL values.

Syntax:

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
LEFT JOIN Orders ord
ON Cust.Id = ord.CustomerId;

Output:

Id Name Amount Date

———– ————————————————– ————————————— ———-

1 Mahedee Hasan NULL NULL

2 Hamidur Rahman 4000.00 2014-01-10

2 Hamidur Rahman 5000.00 2014-01-10

3 Jamilur Rahman 3000.00 2014-02-13

4 Hasan Sarwar 600.00 2014-03-22

5 Kamal Hossain NULL NULL

6 Imran Khan NULL NULL

7 Abu Sayem NULL NULL

�

RIGHT JOIN/RIGHT OUTER JOIN
Right outer join returns all the rows from the right table in conjunction with the matching rows from the left table. If there are no columns matching in the left table, it returns NULL values.

Syntax:

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
RIGHT JOIN Orders ord
ON Cust.Id = ord.CustomerId;

Output:

Id Name Amount Date

———– ————————————————– ————————————— ———-

2 Hamidur Rahman 4000.00 2014-01-10

2 Hamidur Rahman 5000.00 2014-01-10

3 Jamilur Rahman 3000.00 2014-02-13

4 Hasan Sarwar 600.00 2014-03-22

NULL NULL 800.00 2014-03-22

FULL JOIN /FULL OUTER JOIN
Full outer join is combines left outer join and right outer join. It returns row from either table when the conditions are met and returns null value when there is no match

Syntax:

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
FULL JOIN Orders ord
ON Cust.Id = ord.CustomerId;

Output:

Id Name Amount Date

———– ————————————————– ————————————— ———-

1 Mahedee Hasan NULL NULL

2 Hamidur Rahman 4000.00 2014-01-10

2 Hamidur Rahman 5000.00 2014-01-10

3 Jamilur Rahman 3000.00 2014-02-13

4 Hasan Sarwar 600.00 2014-03-22

5 Kamal Hossain NULL NULL

6 Imran Khan NULL NULL

7 Abu Sayem NULL NULL

NULL NULL 800.00 2014-03-22

�

SELF JOIN
The SQL SELF JOIN is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.

�

Syntax:

SELECT A.Id, A.Name, B.Name AS Introducer
FROM Customers A, Customers B
WHERE A.IntroducerId = B.Id

Output:

Id Name Introducer

———– ————————————————– ————————————————–

1 Mahedee Hasan Hamidur Rahman

2 Hamidur Rahman Mahedee Hasan

3 Jamilur Rahman Hamidur Rahman

4 Hasan Sarwar Jamilur Rahman

5 Kamal Hossain Hasan Sarwar

6 Imran Khan Kamal Hossain

7 Abu Sayem Imran Khan

�

CARTESIAN JOIN/CROSS JOIN
The SQL cross join produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause uses in the second table

Syntax:

SELECT cust.Id, cust.Name, ord.Amount, ord.[Date]
FROM Customers cust, Orders ord

SELECT cust.Id, cust.Name, ord.Amount, ord.[Date]
FROM Customers cust CROSS JOIN Orders ord

Output:

Id Name Amount Date

———– ————————————————– ————————————— ———-

1 Mahedee Hasan 4000.00 2014-01-10

2 Hamidur Rahman 4000.00 2014-01-10

3 Jamilur Rahman 4000.00 2014-01-10

4 Hasan Sarwar 4000.00 2014-01-10

5 Kamal Hossain 4000.00 2014-01-10

6 Imran Khan 4000.00 2014-01-10

7 Abu Sayem 4000.00 2014-01-10

1 Mahedee Hasan 5000.00 2014-01-10

2 Hamidur Rahman 5000.00 2014-01-10

3 Jamilur Rahman 5000.00 2014-01-10

4 Hasan Sarwar 5000.00 2014-01-10

5 Kamal Hossain 5000.00 2014-01-10

6 Imran Khan 5000.00 2014-01-10

7 Abu Sayem 5000.00 2014-01-10

1 Mahedee Hasan 3000.00 2014-02-13

2 Hamidur Rahman 3000.00 2014-02-13

3 Jamilur Rahman 3000.00 2014-02-13

4 Hasan Sarwar 3000.00 2014-02-13

5 Kamal Hossain 3000.00 2014-02-13

6 Imran Khan 3000.00 2014-02-13

7 Abu Sayem 3000.00 2014-02-13

1 Mahedee Hasan 600.00 2014-03-22

2 Hamidur Rahman 600.00 2014-03-22

3 Jamilur Rahman 600.00 2014-03-22

4 Hasan Sarwar 600.00 2014-03-22

5 Kamal Hossain 600.00 2014-03-22

6 Imran Khan 600.00 2014-03-22

7 Abu Sayem 600.00 2014-03-22

1 Mahedee Hasan 800.00 2014-03-22

2 Hamidur Rahman 800.00 2014-03-22

3 Jamilur Rahman 800.00 2014-03-22

4 Hasan Sarwar 800.00 2014-03-22

5 Kamal Hossain 800.00 2014-03-22

6 Imran Khan 800.00 2014-03-22

7 Abu Sayem 800.00 2014-03-22

�

Additional Information Related JOIN

Left Outer Join Where Null
Left outer join where null returns all the rows from the left table in conjunction without the matching rows from the right table.

Syntax

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
LEFT JOIN Orders ord
ON Cust.Id = ord.CustomerId
where ord.CustomerId is null

Output

Id Name Amount Date

———– ————————————————– ————————————— ———-

1 Mahedee Hasan NULL NULL

5 Kamal Hossain NULL NULL

6 Imran Khan NULL NULL

7 Abu Sayem NULL NULL

�

Right Outer Join Where Null
Right outer join where null returns all the rows from the right table in conjunction without the matching rows from the left table.

Syntax:

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
RIGHT JOIN Orders ord
ON Cust.Id = ord.CustomerId
where Cust.Id is null

Output

Id Name Amount Date
———– ————————————————– ————————————— ———-
NULL NULL 800.00 2014-03-22

Full Outer Join Where Null
Full outer join is combines left outer join and right outer join. It returns row from either table when the conditions are met and returns null value when there is no match

Syntax

SELECT Cust.Id, Cust.Name, ord.Amount, ord.[Date]
FROM Customers Cust
FULL OUTER JOIN Orders ord
ON Cust.Id = ord.CustomerId
WHERE Cust.Id is null
OR ord.CustomerId is null

Output

Id Name Amount Date

———– ————————————————– ————————————— ———-

1 Mahedee Hasan NULL NULL

5 Kamal Hossain NULL NULL

6 Imran Khan NULL NULL

7 Abu Sayem NULL NULL

NULL NULL 800.00 2014-03-22

�

Recovering SQL Server Database from Suspect Mode

Sometimes we have to face a critical situation when SQL Server database going to Suspect Mode. In that moment no work can be done on database. Database may go into suspect mode because the primary file group is damaged and the database cannot be recovered during the startup of the SQL Server

Reason for database to go into suspect mode:

Data files or log files are corrupt.
Database server was shut down improperly
Lack of Disk Space
SQL cannot complete a rollback or roll forward operation.

How to recover database from suspect mode:

1. Change the status of your database. Suppose database name is “BluechipDB”

EXEC sp_resetstatus '';

Example:�

EXEC sp_resetstatus 'BlueChipDB'

�

Set the database in “Emergency” mode

ALTER DATABASE  SET EMERGENCY;

Example:�

ALTER DATABASE BlueChipDB SET EMERGENCY

Check the database for any inconsistency

DBCC CHECKDB('');

Example:�

DBCC checkdb('BlueChipDB')

4. If you get any error after executing DBCC CHECKDB then immediately bring the database in SINGLE USER MODE by running following query. If no error found then you need not execute the following query.

ALTER DATABASE  SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Example:

 ALTER DATABASE BlueChipDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

5. For safety, take the backup of the database.

6. Run the following query as next step. Remember while using the below query, that uses REPAIR_ALLOW_DATA_LOSS, is a one way operation that is once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database in step 5 mentioned above.

DBCC CHECKDB ('', REPAIR_ALLOW_DATA_LOSS);

Example:�

DBCC CheckDB ('BlueChipDB', REPAIR_ALLOW_DATA_LOSS)

7. Finally, bring the database in MULTI USER mode

ALTER DATABASE  SET MULTI_USER;

ALTER DATABASE [BlueChipDB]  SET MULTI_USER

Refresh your database server and verify the connectivity of your database. Now users should be able to connect to the database properly. If any data loss, you can restore database – backup taken in step 5.