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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-12-07 : 11:08:12
|
| How to backup table in sql server 2005SQL IN Minds |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-12-07 : 11:09:10
|
| just use export/import wizard with different name. it will work. |
 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-12-07 : 11:12:58
|
| I don't want to use the wizardSQL IN Minds |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-12-07 : 11:14:07
|
| Then it's not possible in 2000 and 2005. Only in SQL server 6.5 you can backup one table.Sorry |
|
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2007-12-07 : 11:31:59
|
| You can use bcp from command line if don't want to use the wizard but this will only copy the data and you need a sql script to create table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-07 : 23:01:37
|
| You can backup table if it's in separate file group. |
|
|
|
|
|
|
backup tables tables