Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to manually retrieve a few rows from a SQL Server 2008 database backup. Normally I create a new database, restore the database backup to the new database, and run my queries. The database is huge, however, so it takes forever to restore.

Is there an easier way to get at the older data?

share|improve this question

3 Answers 3

up vote 7 down vote accepted

There is no way to restore either a single table or a few rows in SQL server without a third party product. If the table for which you are trying to retrieve few rows is in a separate file group you can restore only that filegroup (assuming you have Enterprise edition).

Else use a third party product like Quest Litespeed. I believe it has a feature that lets you to restore just a table from backup.

If your database is huge, use backup compression (available in SQL 2008 R2 standard and enterprise edition). Usually, a compressed backup takes less time to restore.

share|improve this answer

Check out red-gates virtual restore product:

http://www.red-gate.com/products/dba/sql-virtual-restore/

It will give you access to your backups significantly faster than a regular restore.

share|improve this answer

You can use ApexSQL Restore – a SQL Server tool that attaches both native and natively compressed SQL database backups and transaction log backups as live databases, accessible via SQL Server Management Studio, Visual Studio or any other third-party tool. It allows attaching single or multiple full, differential and transaction log backups as well as mounting backup sets to a specific point in time

Disclaimer: I work as a Product Support Engineer at ApexSQL

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.