Restoring just a table from a full backup

Hot Topic

sp_dropsubscription, article
Merge Replication Updates on Initialise (SQLServer 2005)
Inserting data from one table to another
Reporting Services 2005 as standalone?
Display datasource information in header
Is there Simple way to get all dimension & Hierarchy levels from a database?
The AcquireConnection method call failed with error code 0xC0202009.
File growth problem in 2005
Reporting Services 2005 - Simple Q
Accessing analysis services from asp.net application

SQL Server

Data Source passwords in Config Files
SSIS Package OLE DB Connection Issue
User log-on, allowing administrator only
Adding data to a SQL Server Express Database
How to Secure transport of file to FTP Server from SSIS...options??
How to run an exe in the SSIS scripting task
Restore Master Key
About Login Account
CLR Trigger
Tell Us Your Express Story and Win $100!

Restoring just a table from a full backup

is there a way to restore certain tables from a full backup

Answer this question

Restoring just a table from a full backup

  • Ricardo Tomé

    When you use for example SQL LiteSpeed for dumping (also usefull for quick and compressed dumping) there is an option in the admin tool for SQL LiteSpeed where you can restore a single object (view, sp, table, function etc) from a dump.

    I have very good experience with SQL LiteSpeed.

  • kamran_kamaei

    Simple answer: No

    Although there might be a way if you used a seperate file group for that table.

     



  • PDACSKIVE

    try some 3rd party tools.



  • Edmaneiro

    I am not sure. We are using Great Plains 9 and my bose told me he just wants to backup and restore payroll.

  • ihope

    great idea

  • Bao Baboon

    You can restore the backup with other name, then copy the desired table from one database to the other.

  • tosch9

    I believe that is what I will do. thanks.
  • Restoring just a table from a full backup
Answer this question