Home All Groups Group Topic Archive Search About

How to take a BACKUP of a single or more Tables in Sql Server

Author
13 Jul 2006 10:30 PM
ch.adilaziz
I want to know that how to take a BACKUP of a Table in Sql Server.If
any one can help me with this issue. Thanks

Author
13 Jul 2006 11:13 PM
Andrew J. Kelly
There is no way to backup a table per say. If you create a secondary file
group and place that table in the file group you can then do file group
backups. But there are caveats to backing up at the file / filegroup level
that you should be aware of. You can find more details about partial backup
&  recovery in BooksOnLine.

--
Andrew J. Kelly SQL MVP

<ch.adila***@gmail.com> wrote in message
Show quote
news:1152829818.042798.264200@s13g2000cwa.googlegroups.com...
>I want to know that how to take a BACKUP of a Table in Sql Server.If
> any one can help me with this issue. Thanks
>
Author
13 Jul 2006 11:45 PM
Arnie Rowland
You could use DTS (SQL2000) or SSIS (SQL 2005) and export to a comma
delimited text file (or a *.mdb file). And the same file can then be
imported into the same or a different SQL server file. WARNING: This method
provides NO inherrent data security.

NOT recommended for any form of production work. Only for weird, oddball,
unusual, not normal situation.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



<ch.adila***@gmail.com> wrote in message
Show quote
news:1152829818.042798.264200@s13g2000cwa.googlegroups.com...
>I want to know that how to take a BACKUP of a Table in Sql Server.If
> any one can help me with this issue. Thanks
>

AddThis Social Bookmark Button