Single table backup using sqlcmd

Question

Single table backup using sqlcmd

kamleshsinhchauhan

Old Hand

Points: 327
More actions
January 31, 2012 at 2:06 am

#254588

I need to take a single table backup using sqlcmd???? How can i take a backup of particular table using sqlcmd??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

poojari045 SSChasing Mays Points: 654 More actions · Answer 1

There is no option to backup on table level. but you can use select * into to copy the table data and definition. other option is you can move the table into different filegroup and take filegroup backup.

With Sqlcmd you can copy the to run a query and just save the output to a file

sqlcmd -Q "SELECT * FROM AdventureWorks2008R2.Person.Person" -o MyOutput.txt

kamleshsinhchauhan Old Hand Points: 327 More actions · Answer 2

How can move table into filegroup and take a backup from that???

Please explain

poojari045 SSChasing Mays Points: 654 More actions · Answer 3

kamleshsinhchauhan (1/31/2012)
How can move table into filegroup and take a backup from that???
Please explain

Here is the steps to move table to different group

http://www.sqlservercentral.com/articles/Administration/64275/

djohnselvaraj Newbie Points: 1 More actions · Answer 4

Use this query

Select * into tablename_bak from tablename