Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to take backup & restore for one table? Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 10:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 12, 2009 5:33 AM
Points: 68, Visits: 215
How to take backup & restore for one table?
Post #516069
Posted Thursday, June 12, 2008 12:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 1,190, Visits: 590
There 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...


MohammedU
Microsoft SQL Server MVP
Post #516207
Posted Thursday, June 12, 2008 1:41 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316
That'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.

-- You can't be late until you show up.
Post #516234
Posted Thursday, August 7, 2008 4:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2008 9:17 PM
Points: 5, Visits: 8
there is command to take back up of table
Post #548170
Posted Thursday, August 7, 2008 6:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316
Not 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.

-- You can't be late until you show up.
Post #548232
Posted Friday, August 8, 2008 3:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 9, 2010 5:33 AM
Points: 34, Visits: 125
Can 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 -

Tom
Post #548959
Posted Friday, August 8, 2008 6:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316
Absolutely. 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 relatively 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.

-- You can't be late until you show up.
Post #549048
Posted Wednesday, September 15, 2010 2:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 29, 2010 5:23 AM
Points: 1, Visits: 1
Right 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. Kumaresh
Post #986086
Posted Wednesday, February 6, 2013 5:38 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 4, 2014 2:47 AM
Points: 479, Visits: 520
Hi SSCrazy -
In that case, please explain about the filegroup restoration chain..
Post #1416437
Posted Wednesday, February 6, 2013 6:50 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 42,771, Visits: 35,870
5 year old thread. Please post new questions in a new thread. Thanks


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1416484
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse