InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:00:28 GMT20http://www.sqlservercentral.com/Forums/Topic516069-24-1.aspx5 year old thread. Please post new questions in a new thread. ThanksWed, 06 Feb 2013 06:50:50 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxHi SSCrazy - In that case, please explain about the filegroup restoration chain..:-)Wed, 06 Feb 2013 05:38:17 GMTkarthik babuhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxRight CLick on database-Tasks-Generate Scripts-select a database-Choose script options(select the script data option set to true)-and proceed further....finally you can have the table structure coding along with the data.(These steps for sql server 2008...you may use this tips for other version)D. KumareshWed, 15 Sep 2010 02:30:42 GMTdkumaresh 50476http://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxAbsolutely. That's also a good way of doing backups of VLDBs, especially if using native SQL. Allows you to slice it and dice it to meet your business recovery needs. We had a manufacturing environment where we knew 2/3 of our tables were [b]relatively[/b] static and truly only needed to be backed up weekly. They were put into their own file group and backed up accordingly. But our inventory tables were constantly being updated and needed nightly backups. As the database grew, this was the best way to ensure we had what we needed. Then we went with a third party tool and it all became moot - full backups of everything nightly. Look up "BACKUP, filegroup backup" in BOL.Fri, 08 Aug 2008 06:19:50 GMT tosscrosbyhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxCan you put the table into it's own file group and just run a backup on that filegroup? I'm addressing this more to the experts - TomFri, 08 Aug 2008 03:24:42 GMTtrhhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxNot in native SQl 2000 or SQL 7. See the prior posts for the solutions for these platforms. Also, if you have a solution, please state it. Simply writing "there is command to take back up of table" isn't helping at all. Show a script or be more decriptive as to what the point is that you're trying to convey. Thanks.Thu, 07 Aug 2008 06:31:00 GMT tosscrosbyhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxthere is command to take back up of tableThu, 07 Aug 2008 04:59:16 GMTdba_chhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxThat's about the only way in SQL2K. There are third party tools, like LiteSpeed that will allow you to restore a table (or other objects) individually but I don't recall if you can backup individual objects (I don't believe so). I agree with MohammedU, DTS or BCP are probably the easiest (read cheapest!) way to go.Thu, 12 Jun 2008 13:41:27 GMT tosscrosbyhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxThere is no option in sql server to backup the single table using backup command...but you can use DTS or BCP to copy the data and generate the table script...Thu, 12 Jun 2008 12:58:34 GMTMohammedUhttp://www.sqlservercentral.com/Forums/Topic516069-24-1.aspxHow to take backup & restore for one table?Thu, 12 Jun 2008 10:04:15 GMTsharma-691993