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

Question

Pankaj Pandey · Answer

use this query... select * into newtablename from yourtablename note--you do not need to create a table manually, just put a table name on place of newtablename in query and run,,, ex.. select * into pkp_backup from pkp

Jaganathan Bantheswaran · Answer

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

RIM Singh · Answer

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.

Iftikar Hussain · Answer

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

Sanjeeb Lenka · Answer

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/

Riyaz Akhtar · Answer

I am not sure about how to take backup only tables but Complete database you can take backup, see below example: BACKUP DATABASE NORTHWND TO DISK = 'c:\NORTHWND_1.Bak'

Jaganathan Bantheswaran · Answer

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/

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

Answers (7)