is it possible to just restore particular tables from a back up of a database

Hi,

I backed my sql server database on Fri at 3:15pm and then tried importing some tables individually from a different database and but that didnt work out too good, so is there a way i can just restore particular tables from the backup.

any help will be appreciated.

regards,

Karen

AFAIK, you need to restore the db first to retrieve any information from the files.|||I don't think it is possible to just restore one table. What I have done in the past is to restore the backed up database with a new name and then copy the table from the backup to the operational.|||

Restore database with different name and next copy data from tables you need to your destination

Thanks

|||

thanks a lot for your answers i just restored the database to it previous state

Regards,

Karen

sql