Single Table BACK Up

Question

Post reply

Single Table BACK Up

kollisudheer27

Mr or Mrs. 500

Points: 581
More actions
August 23, 2010 at 9:04 pm

#239315

Hi
How do take the single table backup plz help me....
plz help me ....

Viewing 11 posts - 1 through 10 (of 10 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

You can't take a single table backup, per se. You can export a table using the export wizard or BCP.

kollisudheer27 Mr or Mrs. 500 Points: 581 More actions · Answer 2

kollisudheer27

Mr or Mrs. 500

Points: 581

August 23, 2010 at 9:23 pm

#1210766

thanku very much...

Derrick Smith SSChampion Points: 10833 More actions · Answer 3

Or if you're looking to just make a quick copy of the data..

SELECT * INTO dbo.tblname_backup_date FROM dbo.tblname

I do this regularly before a data update happens that could potentially mess things up. Just make sure you get rid of your backup tables after you're sure you don't need them any more.

pankushmehta Ten Centuries Points: 1217 More actions · Answer 4

If you export the data, you do not really export the metadata. you need you take note of the constraints, indexes, defaults etc.

NickDBA Hall of Fame Points: 3792 More actions · Answer 5

If your table is on a seperate filegroup, you can back up the filegroup

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

BaddaBing (8/27/2010)
If your table is on a seperate filegroup, you can back up the filegroup

After that how he will restore??

NickDBA Hall of Fame Points: 3792 More actions · Answer 7

NickDBA

Hall of Fame

Points: 3792

August 31, 2010 at 7:37 am

#1214283

Partial Restore etc

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

You can backup and restore from a filegroup, but you need a full backup on which to base this. I'm not sure a filegroup backup would fit well in this situation.

http://msdn.microsoft.com/en-us/library/ms189860%28v=SQL.100%29.aspx

If this is read only data, then perhaps, but otherwise, I would just export the data. I'm assuming you mean the data is important here, not all the PK/FK/constraints.

NickDBA Hall of Fame Points: 3792 More actions · Answer 9

NickDBA

Hall of Fame

Points: 3792

August 31, 2010 at 8:42 am

#1214362

Point well made (and taken)...:-)

ananthbhaskar Right there with Babe Points: 783 More actions · Answer 10

Not a recommended idea, but you can also do this!

export that single table into a sample DB (just created for this purpose)

and then backup that DB , by this way there will be only one object in that DB , its ur table and the meta data all the constriant will also be present.:-)