How can i create a backup of table with data in Sql Server ?

@Iftikar Hussain, If he is the same person who posts & accepts answer, then Admins can block the user Pankaj Pandey.

hiii,

here i am asking for backup the table not the databases, so why i am going to accept your answer?..

If you want to let me accept your answer then first read closely my problem and then reply correct.

And if you are not interested then don't answer my questions, but can not say to any one who want to help me.

I am fresher and don't have too knowledge then i need always help.


thnx.

guys don't spend your time by answering your comment on the post raised by RIM Singh as it will always accept Pankaj Pandey . Since both are same person. you can see all previous post of RIM Singh

check for full database back up:

http://blog.sqlauthority.com/2008/07/03/sql-server-2008-introduction-to-new-feature-of-backup-compression/

script back up

http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

I am not sure about how to take backup only tables but Complete database you can take backup, see below example:

HI,

This link may help you. 

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/