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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 back up of tables

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2008-04-16 : 23:36:43
i need to back up a table in a adtabase so that when i update the table and something goes wrong i can bring back the original copy .

how about the .bak ?

thanks in advance

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-04-17 : 00:15:09
why not backup the whole db?

alternative would be to dump the table to a txt file with bcp.


elsasoft.org
Go to Top of Page
   

- Advertisement -