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 |
|
gsbeula
Starting Member
2 Posts |
 Posted - 2008-03-22 : 00:20:26
|
| I wish to take only table backup from database... The resaon is database size is too large... Pls help me if u can...... i am using SQL Server 2000..... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-22 : 00:45:39
|
| You can't unless the table is in its own filegroup, then you can backup that filegroup. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-22 : 11:36:09
|
| Use export/import wizard and give it different name. Make sure you have to apply all contraints manually to make it similar. |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-03-23 : 05:32:42
|
| I suppose in theory you could use select into from another db or server and make a copy of your table as well. The filegroup method is definitely the "best practice" way of doing things.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Table Backup