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 |
|
raul11
Starting Member
48 Posts |
 Posted - 2011-09-24 : 10:36:05
|
| I've got a backup made using the regular SQL Server 2005 backup command. Is there a way to restore just a single table, not the whole DB? |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-24 : 11:00:22
|
| No, you have to restore the backup to a new, temporary, database name and then copy over the table. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-24 : 11:00:43
|
.. and then Drop the temporary database  |
|
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-10-13 : 09:08:54
|
| How about having table-level backup? My connect item was rejectedMadhivananFailing to plan is Planning to fail |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-14 : 01:24:33
|
| unlikely to happen.--Gail ShawSQL Server MVP |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-12-15 : 03:16:36
|
quote:
Originally posted by paultech
Red Gate has some pretty good tools for row-level restore (SQL Data Compare and SQL Backup), but they come at a pricehttp://www.red-gate.com/products/dba/sql-backup/
Can you highlight the change you made? This is the old threadMadhivananFailing to plan is Planning to fail |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
restore