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:

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

1

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

2

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

3

    1. Here, I am choosing MSSQL option

4

    1. 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
    2. On connection, click Connect
    3. On generation of File saved at the desired path dialog box, click OK

5

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

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

4

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

01-Customer02

Orders

02-Orders02

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

03-InnerJoin

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.

04-Left join

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.

05-Right join

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

06-Full Join

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

07-crossjoin

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.

08-left Join and Null

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.

08-Right Join and Null

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

10-full Join and Null

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:

  1.  Data files or log files are corrupt.
  2.  Database server was shut down improperly
  3.  Lack of Disk Space
  4.  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'

  1.  Set the database in “Emergency” mode
ALTER DATABASE  SET EMERGENCY;

Example:

ALTER DATABASE BlueChipDB SET EMERGENCY
  1.  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
  1.  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.