In this article, we explore possible alternates to an object level recovery run in SQL Server.
Databases stored in SQL Server are often very large and heavy files. If one needs to restore only one table from the whole database, then restoring the whole database does not make sense. It will not only take up too much time, but also resources. The Object Level Recovery or Table Level Recovery was one feature in SQL Server which could be used for restoring just a single table, but the feature got done away with. But this did not leave the user with no other option to do so. The explicit feature might have been removed, but the application still provides users with alternatives for the feature, only if one explores. Given below is a list of features that can be used as alternatives for Object Level Recovery.
- Restoring Current Databases in Another Database – This is one of the most feasible and most easily executable option. If you opt for restoring current databases in another database, desired tables can then be copied to the databases. While using this option, you will have to perform a full restore or in other words point in recovery restoration. However, this too has its own drawbacks, it is best to opt for this method when the database you are about to restore is not a very large one, or it might end up taking a lot more disk space and making the system slower.
- Take Snapshots of Databases – If you want to restore a table from a databases that is very heavy, it is suggested to make use of this method. If in any case there is any kind of problem, it can be resolved within the snapshot, since it acts as a data source. However it is important that you already have the snapshot available with you, before the problem arises. If there are any ongoing recurrent or parallel updates in the table, by multiple users, this option might not work. You need to have a snapshot of all changes being made on the table.
- Use SQL Server View – This will require you to have a secondary database, in which you can move your table, this database will be backed up separately, allowing little data restoration at the time of recovery. This data can be the one in the table you want to recover. This is on of the best methods, since it allows the user to make a selection from table contents. However, creating a view will require you to drop and rename a table within the original database.
Recovering tables from a given database becomes important at times, either of the above explained methods can be used for doing so. The user is advised to thoroughly go through all the pros and the cons of the methods. The selection should be made based on your requirements and your SQL environment. You can also opt for doing it using a third party fix SQL Server software and not doing it manually. This can save a lot of time and give desired results.
Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access corruption and sql recovery software products. For more information visit www.datanumen.com