Data Recovery by Software

PowerControls™ SQL Recovery Software

Restore just the table you need, not the entire database saving you hours of time.

Ontrack PowerControls for SQL allows you to search, preview and restore tables from native SQL BAK files, offline MDF, LDF and NDF files, or a storage tier snapshot from a SAN environment. 

boxshot-opcsql-shadow

Save time when restoring dropped Microsoft SQL Server tables.

Selectively migrate tables for dev and test, saving cloud data movement and storage cost. Restore just the table you need, not the entire database saving you hours of time.

Ontrack PowerControls for SQL Product Features

List Icon
Search and restore a single table from a database backup in seconds.
Hourglass Icon
Easily preview table contents before restoration.
Drag and Drop Icon
Drag and drop table recovery: no T-SQL or PowerShell scripts needed.
OPC_SQL_Boxshot_DE

Subscribe today!

partners-fist-bump

Let us build a license for your enterprise.

  • Customize a license for your business needs
  • Licenses available for the capacity you need for small businesses through the largest global enterprises
  • License 1, 2 or all Ontrack® PowerControls™ applications depending on your needs
  • Commercial licenses available for MSPs, ediscovery and other service providers
  •  brands, specialized controller chips, and many other SSD specific issues.

Powercontrols for Exchange FAQs

How does a page-level restore improve SQL Server recovery provisions?

For very large Microsoft SQL Server databases, a complete restore operation can take many hours. During this time the database cannot be used to prevent data being entered and lost as information is copied back from tape or disk. In a high-availability environment, any downtime is costly, so keeping it to a minimum is essential.Fortunately, page-level restore techniques can be used to keep recovery times to a minimum by reducing the amount of data that needs to copied back from the backup media. Since the release of Microsoft SQL Server 2005, DBAs have had the option of carrying out a 'page level restore' which allows them to recover a 'handful' of pages, rather than having to restore entire datasets and copy the information back into the original database.The page-level restore operation is perfect for situations where data becomes corrupted during writes through a faulty disk controller, misconfigured antivirus software or an IO subsystem. Better still, restore level operations can be performed online for Enterprise editions of Microsoft SQL Server.

How Does In Memory Computing Affect SQL Server Recovery?

Built-in provisionsHekaton allows DBAs to select high priority tables and objects that need to be stored in RAM for super-fast querying. However, the underlying architecture has also been engineered to create a localized backup of that data:Transaction logJust like a standard disk-based database, Hekaton also relies on a transaction log record to track operations, and assist with SQL Server recovery. To ensure complete coverage, Hekaton integrates both disk-based and memory-based transaction logs, writing both to disk in batches.Understanding the Data FileRather than the traditional page structures used for data rows, Hekaton uses a pair of sequential files - Data and Delta files. The Data file contains free-form data rows that are then linked using in-memory indexes. Every time a row is changed by an INSERT or UPDATE statement, the changed row is appended to the end of the Data file.To maintain the speed of operation and to maintain an accurate audit trail, when a row is deleted or updated from an in-memory table, it is not removed from, or changed in the Data file.

What Do I Need For A Successful Microsoft SQL Server Database Restore?

A full backupJust like any other file on the network, the key to a successful database recovery is to have a full, current backup of the MDB and MDF files. You should be taking incremental copies of the database files at least once a day, combined with a full backup at least once a week.A log file backupA 100% accurate database restore is reliant on having a completely up-to-date set of log files that corresponds with data access and update operations. For industries that are heavily regulated, like finance and banking, the log files are essential to prove compliance.Microsoft is keen to point out that you must have "enough” log backups available for a restore sequence, including the tail-log backup, before beginning the process.Sufficient spare disk capacityIn order to test the restored data is correct, you will need to restore the database elsewhere first. This will then give you a chance to test the restored data and ensure that there is no corruption, and that you have an up-to-date set of records that gives a true indication of state before the crash/deletion/corruption.

What Our Customers Say About Our Data Recovery Services

TrustScore /5

Displaying 4-5 Reviews

reviews

Partnerships and API Integration

Resell Icon
Resell to your customers.
  • Grow revenue while saving your customers time and money
  • Generous partner discounts
  • Resell on a project-by-project basis or to larger clients who manage their own data on-premises
Provide Hosting Icon
Provide hosting services.
  • Rapidly recover items for your business customers and end users
  • Differentiate your service offerings with granular restore
  • Commercial unlimited use licenses
eDiscovery Icon
For eDiscovery service providers.
  • Extract items from backups for your client projects
  • Forensically sound with no impact to metadata
  • Commercial unlimited use licenses
Backup Icon
For backup and storage OEMs.
  • Bundle with your data protection platform to provide item level granular restore
  • Licensing aligned to your business model
  • Option to integrate the API to run the Ontrack PowerControls libraries within your user interface

Experiences that matter

Ontrack has extensive experience with all types of data loss scenarios. Our goal is to provide our customers with peace of mind in the event of data loss due to hardware failure, human error, natural disasters or cyberattacks.

39

Years

In the business

1

Million+

Customers and growing

120

Petabytes+

Of recovered data

73,661,023,683

Of data files recovered over the last twenty years... and more and more every day!

Start your data recovery now with a free consultation.

Contact our team of experts.

KLDiscovery Ontrack Canada Co, 155 Gordon Baker Rd Suite 100, North York, M2H 3N7, Canada (see all locations)