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-05-16 : 09:42:43
|
| Olivier Lejeune writes "Is possible to backup only specific tables from a database and not all of them?Regards,Ol." |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-16 : 10:21:52
|
| With SQL Server you have four backup types:"Full", "differential", "transaction log" and "file and filegroup".So with SQL Server backup you cannot choose which table you want to backup.One possibility is to do it with DTS.There are wizards available on line.Please refer to BOL for details.Franco |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-16 : 11:51:50
|
| Well you can do it, but you had to have set it up in a certain way. You could have moved your tables into filegroups and then backed up the filegroup. So you could have one table into one filegroup so that you can backup a single table, but I would not recommend this. Anyway, if you want to backup a table, I usually just run SELECT * INTO, or use DTS, or use bcp (don't forget the table script though).Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-16 : 14:24:53
|
| Tara,I'm thinking they're just looking for DTS or bcp...What version of SQL are you dealing with?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-16 : 14:27:43
|
quote:
Tara,I'm thinking they're just looking for DTS or bcp...
Which is why I mentioned DTS and bcp!Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-16 : 14:35:03
|
| I gotta get my eyes checked...sorry, it's been a loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong weekBrett8-) |
|
|
|
|
|
|
|
|
Partial Backup