November 27, 2013 at 3:59 am
Hi All,
I have 500 tables in a database. i want to take the backup and restore the 3 tables along with its data and properties. how can i take back up and restore those tables can anyone tell me about that process.
Thanks,
Avinash
November 27, 2013 at 4:03 am
You can use Export/Import Wizard to achieve this task. You can also use bcp to achieve this.
can also try: select * into new_table from old_table
November 27, 2013 at 6:08 am
Hi,
i too go for export table option rather than backup/restore just for few tables.
November 27, 2013 at 8:03 am
How big are the tables? If the are each several GB each then I'd consider going with backup/restore then drop the extra tables.
If they are relatively small I would go with export/import.
You need to weigh up the pros and cons of both.
You cannot natively restore single tables.
November 27, 2013 at 8:11 am
I see several options. Import/Export is one option, so is Bulk Copy. I use a Red-Gate tool SQL Data Compare which may be a bit more than what you are looking to do, but will do the trick as well.
Good luck.
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman
November 27, 2013 at 8:33 am
Also, some third-party backup utilities, such as Litespeed, include object-level restore. I've never used that feature so I don't know how well it works.
John
November 28, 2013 at 12:00 am
Thank you all.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply