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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-15 : 06:57:25
|
| Swaminathan M.N writes "Hi All,I would like to backup a particular table available in a database... is it possi ?rgdssam" |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-08-15 : 07:15:23
|
| Hi sam,I don't think you can backup a single table in the way you backup a db.Well, only if it's the only table in a filegroup, it would work, I think.However, you can use DTS Export wizard to export the data to flat file, Access....Cheers,Frank |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-15 : 07:18:02
|
| Yes, filegroup backup would be the way to do it. You'd have to create a separate filegroup and move the table(s) to it. Books Online has more details under "filegroups" and "backup". |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-15 : 12:36:45
|
| This reminds me of one of the things that I miss about SQL Server 6.5: the ability to restore a single table. Why did they remove that feature? Yes I know you could do it with filegroups now or even restore the whole database to a different name and then copy over the single table that you want, but it was so easy back then.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-15 : 19:35:19
|
| Chad had explained this better a while ago, but essentially it came down to data integrity. The argument was completely valid. It's still an issue using filegroups too, but less so. I also miss LOAD TABLE, but now I also think that it was a step in the right direction. The old SQL Server devices made it especially difficult to manage databases and tables. I certainly don't miss devices, and filegroups can do far more. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-08-16 : 12:00:37
|
quote:
Originally posted by tduggan
This reminds me of one of the things that I miss about SQL Server 6.5: the ability to restore a single table.
Here's another feature that I miss - SQL 6.5 also let us mirror the transaction logs at the database level. That is (was) a nice bit of insurance to have if you were to lose a controller. oh well.-ec |
|
|
|
|
|
|
|
|
Can i Backup particular table ( SQL 2000 )