Saturday, September 3, 2016

How to Resume Suspended Database Mirroring in SQL Server ?


Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and minimizes the loss of the data. Redundancy ensures that there is always a one backup copy of the database should remain accessible at the time of updates.

Basically mirroring feature in SQL Server is able to stand the random failures at the several parts when the user is linking between the two servers. It has some in built techniques which are not affected to the outside world. SO the SQL Server user can reboot the servers, connect and reconnect to the link and after that the database mirroring can still be resumed afterwards.

Causes for Database Mirroring Pause

  • No storage space in the primary storage.
  • SQL Server not working properly.
  • The main database is not connected to the mirrored database link.

So, an error is shown to the user while they are performing the database mirroring and all of the sudden it pauses.

Methods to Fix Database Mirroring Pause?

The above error occurs when the mirror server is running out of the space. The SQL Server user will be able to resume the mirroring as soon as the user frees some space. It means that there is no storage left in the primary storage, so in order to resume the database mirroring the user will check if they have any space in the secondary storage then they will free up all the primary storage and store it to the secondary database in order to resume the database mirroring.

Steps to Resume the Database Mirroring In SQL Server

Here are the steps to resume database mirroring using SQL Server Management Studio:

  • First, at the time of database mirroring connect to the principal server instance inside Object Explorer and then click on the server name to expand the server tree.
  • Second, expand the databases and click on the database.
  • Third, now right click on the database and select Tasks and after that click on Mirror. It will open the mirroring page of the Database properties dialog box.
  • Fourth, if the database is already pause then click on Resume button to resume the database mirroring.

Steps to Resume the Database Mirroring Using Transact-SQL

  • Connect to the database engine of the either partner.
  • Click on New Query for the standard bar.
  • Now Enter the following Transact-SQL query in order to resume the database mirroring:

By the use of this command the user can resume the database mirroring when it was paused.


We discussed what is database mirroring and why it is important. In addition, we discussed about what are the causes for database mirroring pause and gave an example for it. We also gave some steps to resume database mirroring using any one of the two platforms. Database mirroring is an important thing as it backups the copy of the database and can be maintained easily at the time of loss of the data or loss of the database file.

Friday, January 1, 2016

Happy New Year Friends

Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.

Thursday, December 31, 2015

SQL Recovery Software: An Ultimate Tool For SQL Database Recovery

SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server, etc. the data in the database may go damaged or corrupted. The recovery of the data can be made possible with SQL Recovery Software. The tool attains an easy recovery of the database files from corruption or damage; no matter how deep the infection is. Both the MDF and NDF files get repaired using the tool and all the triggers, store procedures, tables, functions, etc. in the database are also recovered within seconds.
More On Software
SQL Repair tool restores all the data from the damaged database file of any server such as; Server 2014, 2012, 2008, etc. With the software all the hard deleted data items can be restored without any changes to the data.Being a Windows based software, the tool supports all the versions; Windows 8.1 and below.The Advance scan option recovers entire data when the corruption infection is severe and there is Quick scan mode for minor damage recovery. The tool is supported with the auto-detection option for the selection of NDF files as well as the SQL Server version. Once the restoration of the database files are done, software allows to export the files back to the Server.
Overview Of The Tool
Function Recover SQL Database from corruption
Version 6.2
Size 6.10 MB
Server Support SQL Server 2014, 2012, 2008 / 2008 R2, 2005, etc.
Windows Version Supports Windows 8.1 and below

Outstanding Features of SQL Recovery Software

Scan Modes
The tool is implemented with advanced algorithms for the recovery of the files. The “Scan Mode” option helps to recover the corrupted or damaged Server database files. The tool supports two scan modes; Quick and Advance. If the database file is less corrupted, users can go for “Quick” scan mode or else if the damage is severe, “Advance” scan restores all the data without loss.

Detects Server Version
Suppose, if you don’t know the version of the SQL Server where the database file is saved, there is “Auto detect SQL server file (.mdf) version” choice which will automatically search for the server file version once when the checkbox is ticked. Else, the user can mention the server version directly from the radio options provided but, one should be careful while opting since wrong selection of the server may lead to inconsistency.
NDF File Scan Option
The users can either add multiple files or folders for scanning and recovering. If the added files are to be removed, the tool is sufficient with that feature too. The eminent feature of the NDF option is that, it automatically detects the NDF files when the “Autodetect the SQL server secondary database (.ndf) files” option is selected. If the user doesn’t know the location of the file, auto-detect feature will be of useful; both to search the file and save time. Else, the user can select and provide the files using the “Let me choose the SQL Server secondary database (.ndf) files” choice

Hierarchical Structure
After the restoration of the database files, it shows the content of the files in hierarchical manner. The software will show all the contents such as; stored procedures, tables, triggers, functions, rules, etc. and each of the contents is expandable too. The structuring makes the viewing comfortable and easy.

Export Modes
Once when the files or folders are recovered from the damage, the tool allows exporting the recovered files back to the database itself. Either the user can export to “SQL Server Database” or to “SQL Server Compatible SQL Scripts”. If the user chooses the first option then, will have to provide the server name, database name, the credentials of the server. But, the latter option is usually opted when the server is not present or files are not to be exported to the server for time being. The “SQL Server Compatible SQL Scripts” choice will save the files in scripts and user can later transport the scripts.

Dual Export Option
While exporting the database files to the server or when saving in script forms, the tool facilitates the users with two options. User can export the files either “With only Schema” or “With Schema & Data” options. Both these options are applicable for both the exports i.e. to SQL Server Database or SQL Server Compactible SQL Scripts.

Versions & Its Extents
Demo Version
The capability of the application can be checked using the demo version available. If the user is satisfied will the working then, can go for the purchase option. But, the demo version is limited to the recovery of the files. The exporting and saving cannot be done with the demo version.
License Version
Along with the demo version, the full version is also available in the office website. The Licensed version recovers all the added files or folders and enables to export and save the restored files back to the server, if needed.
Pros & Cons
  • Supports the recovery of both .ndf and .mdf files from damages or corruptions.
  • Enables to scan multiple .ndf files at a time.
  • Automatically selects the SQL Server version for the MDF files, if unknown.
  • Two scanning modes for the recovery of the files.
  • Selects the NDF files automatically, if the user doesn’t know the location.
  • Exports retrieved files back to Server database or saves in Compatible SQL Scripts.
  • Provides facility for exporting either schema only or both schema and data together.
Doesn’t scan and recover LDF files of the database
The Verdict
In the technical point of view, the tool is equipped with all the sufficient features for the recovery of the database files. On the basis of its working, software can be rated as 9.6/10. Though the tool doesn’t recover LDF files, it efficiently restores both MDF and NDF files which are more important than the LDF files. For the repairing of the database files from damage, users can depend on the SQL Recovery Software without a second thought.

Saturday, August 15, 2015

Happy Independence Day - Jai Hind

Wishing you a very

Happy Independence Day

" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.

     Some facts about India 
  1. Indus Valley Civilization is the world’s oldest civilization.So, India is the world’s oldest, most advanced and continuous civilization.
  2. India has the world’s third largest active army, after China and USA but India has never invaded or attacked a country.
  3. Today, India is the world’s third largest economy.
  4. The Tirupati Balaji temple and the Kashi Vishwanath Temple both, receive more visitors than the Vatican City and Mecca combined.
  5. Every 12 years, a religious gathering called the Kumbh Mela occurs in India. It is the world’s largest gathering of people.
  6. Varanasi, also known as Benaras, was called "the Ancient City" when Lord Buddha visited it in 500 B.C., and is the oldest, continuously inhabited city in the world today.
  7. India has third largest Muslim population in the world and has more mosques (300,000 mosques) than any other nation in the world.
  8. Jews and Christians have lived continuously in India since 200 B.C. and 52 A.D. respectively
  9. Two major religions, Buddhism and Jainism, were established in India.
  10. Takshila is said to be the first every university in the world; it started around 700 BC.
  11. Indian Railways employs more than 1.3 million people. That’s more than the population of many nations.
  12. India is the largest democracy in the world. More than 54 crore people voted in the 2014 General Election – more people than the population of USA, UK, Australia and Japan combined.
  13. India has the largest English speaking population in the world.
  14. India’s space program is one of the top 5 space programs in the world and off course we invented water on the moon.
  15. Chess was invented in India.
  16. And discovered the number zero.
  17. And the value of pi. 
  18. And trigonometry, algebra, calculus.
  19. Ayurveda is the earliest school of medicine known to mankind. The Father of Medicine, Charaka, consolidated Ayurveda 2500 years ago.
  20. Cataract surgery and plastic surgery are invented in India
  21. Around the 17th century, India was one of the richest countries in the world.
  22. India is one of the only three countries that makes supercomputers (the US and Japan are the other two).
  23. India has the largest amount of vegetarians in the world. So much so that Pizza Hut had to open their first pure vegetarian restaurant in the country and KFC had to introduce a “vegetarian” menu for India.
  24. India gave the world Yoga, that has existed for more than 5,000 years.
  25. Martial Arts was first created in India.

Proud To Be An Indian