Can we take a Backup of particular Table in a Database

Question

Can we take a Backup of particular Table in a Database

Viewing 3 posts - 16 through 17 (of 17 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

lucien.jarrett (7/22/2011)
It basically creates a new table with the data from a another table. See example
USE AdventureWorks
GO
----Create new table and insert into table using SELECT INSERT
SELECT FirstName, LastName
INTO TestTable
FROM Person.Contact
WHERE EmailPromotion = 2

no and no. Only the filegroup has to be changed. there's no need for a full copy of the data. Moreover it's almost impossible to do without some downtime and rather complexe scripting.

It's way simpler to just move the clustered index!

vino5786 Right there with Babe Points: 743 More actions · Answer 2

TO create a table u need create table permission, For doing BCP out u need minimally select permission on that table... Try bcp out to backup the table

dilip.2585 SSC Rookie Points: 29 More actions · Answer 3

Select * into table_backup from Table will take the backup of 'Table' and keeps the data into 'Table_backup'

Regards,

Dilip