http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspxSQL Server doesn’t have an easy way to take a table backup, so I often use the bcp (Bulk Copy Program) to accomplish the same goal. I’ve mentioned this before, and someone told me when they tried it they couldn’t restore the table – ah the dangers ofen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspx#10297996Thu, 26 Apr 2012 11:42:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:10297996Anil Kolla<p>Hey Greg Low,</p> <p>Well, Generate scripts will work out. But, the problem by generating the script is if the Table is VERY LARGE, SSMS can&#39;t read the very large script.</p> <p>Better find an option to Backup a single table.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10297996" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspx#10262711Wed, 01 Feb 2012 13:07:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:10262711hemanth<p>Y CAN&#39;T we find the option of backng up a table</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10262711" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspx#10150893Thu, 07 Apr 2011 11:00:20 GMT91d46819-8472-40ad-a661-2c78acb4018c:10150893Fwd<p>Thanks Greg, liked the tip.</p> <p>Regards.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10150893" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspx#10021360Tue, 08 Jun 2010 03:43:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:10021360Phani<p>Hi Greg,</p> <p>I think this option is available only in SQL Server 2008. I dont think SQL Server 2005 or earlier versions have this feature.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10021360" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2010/06/03/back-up-a-single-table-in-sql-server.aspx#10020709Mon, 07 Jun 2010 06:17:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:10020709Greg Low<p>Hey Buck,</p> <p>What about in SSMS:</p> <p>Right-click database &gt; tasks &gt; generate sql scripts, then select the table and on the scripting options page, select advanced, choose &quot;schema and data&quot; in types of data to script.</p> <p>Done!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10020709" width="1" height="1">