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 |
|
liewsb
Starting Member
4 Posts |
 Posted - 2005-04-15 : 05:16:54
|
| Anyone can help??I need to do a data backup of one particular table as a file and save it on a CD. How can I do it and also how can I restore it back to the table in the database. Has anyone got any ideas. Pls help. Thanks.Regards,LSB |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-15 : 08:30:44
|
| You can use bcp, DTS, or DMO for this. Here are some examples:http://www.nigelrivett.net/Look at the DMO section.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
kish
Starting Member
45 Posts |
Posted - 2005-04-15 : 08:31:09
|
| What version of SQL Server are you using. YOu cannot backup a single table if using SQL 7/2000.You can however us DTS to transfer the table to Access and can then later transfer it back to SQL. Object level backups are not supported in SQL Server. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-15 : 13:32:16
|
quote:
Object level backups are not supported in SQL Server.
Not natively at least. If you have some room in your budget, you can get a third party backup tool that will restore at the object level. I think both CA Brightstor and Veritas support this with add-on mods. Imceda is also a very nice recovery tool for SQL server and will be fully supporting this in the near future with their Pro distro.If the CD is integral to your needs then the options mentioned by derrick will be your best bet. |
|
|
|
liewsb
Starting Member
4 Posts |
Posted - 2005-04-18 : 23:19:16
|
Hi,Noted. Thanks for all your reply. I will try the DTS method, cos I am using SQL 2000.quote:
Originally posted by liewsb
Anyone can help??I need to do a data backup of one particular table as a file and save it on a CD. How can I do it and also how can I restore it back to the table in the database. Has anyone got any ideas. Pls help. Thanks.Regards,LSB
|
|
|
|
|
|
|
Table Backup