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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-07-23 : 00:15:11
|
| Dear Useri have restore one table of backupfile so it is posible to restore a one table of backfile of database in sql 2005. please send any command or any procedure to it is restore a table thank in advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-23 : 00:27:42
|
you can't restore a table. You have to restore by database. You can restore the database to another db name and then copy the table over
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
onlyforme
Starting Member
25 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-07-23 : 00:36:57
|
| thank to replaybut i have large size database. or it is not posible to restore another dbname. so any another way to restore a table in backup file |
|
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2009-07-23 : 11:40:43
|
| Have you considered restoring the entire .bak file to a new database and then creating a job to copy the contents of the single table to a seperate database? Also, in the future, if you will need this table, have a job copy only the table to a new database, and then have a different job backup that database. That way if you ever need to restore that table again, its much easier. It still has you restoring an entire database. It just so happens that the database you restore will only contain a single table. Just an idea.Craig GreenwoodCraig Greenwood |
|
|
|
Zoomer36
Starting Member
13 Posts |
Posted - 2011-01-07 : 09:40:52
|
| I am trying to restore one table from my backup. I have a backup run every night and found some corruption in one table. Not having lots of experience with this issue, I need some specific help.I am working with SQL 2000.Thanks!hello |
|
|
|
|
|
|
restore tabel in backup file