Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2014-09-29 : 11:47:59
|
| Anyone know if, in SQL 2008, there is a way to backup a database, but specify the tables backed up, and, during the restore on the destination server, restore only those tables in the database? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-29 : 12:46:41
|
| No, not natively. I believe Red Gate SQL Backup software allows it though.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-09-29 : 16:43:21
|
Quest (Dell) LiteSpeed does this, also. In the absence of 3rd party software, the routine is to restore to a second server and copy the table to your target.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
|
|
|
Backup, but only restore specific tables