Table level backup

Question

Post reply

Table level backup

VastSQL

SSC-Dedicated

Points: 36144
More actions
March 24, 2010 at 6:43 am

#219803

Hi Experts,
Is it possible to take a table level backup?
TIA

Viewing 7 posts - 1 through 6 (of 6 total)

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

Paul White SSC Guru Points: 150468 More actions · Answer 1

Ratheesh.K.Nair (3/24/2010)
Hi Experts,
Is it possible to take a table level backup?
TIA

Yes, in some circumstances.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 2

SQL Server 2008 providing table backup or script out table and then use import export?

Carl Federl One Orange Chip Points: 25384 More actions · Answer 3

The "Backup" command works at the database or database file level and there is no support for table level backups.

There are various utilities available such as the Bulk Copy Program (BCP.exe) or SSIS export to create a file with the results of a SQL statement. Neither utility support any type of restore command.

What are you attempting to accomplish ?

SQL = Scarcely Qualifies as a Language

Paul White SSC Guru Points: 150468 More actions · Answer 4

Carl Federl (3/24/2010)
The "Backup" command works at the database or database file level and there is no support for table level backups.

My table resides on its own file group. 😛

@ratheesh:

If you need easy object-level restore, consider a third-party product like this one from RedGate.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

Ratheesh.K.Nair (3/24/2010)
Hi Experts,
Is it possible to take a table level backup?
TIA

Hi

if you want just data and structure then use the following for a quick and dirty

select * into newtable from currentTable

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

If there is a single table that is more important than others, then you might want to consider the use of filegroups and piecemeal restores (as Paul alluded to in his post).

Otherwise, a third party tool might help you get it back.

I create a backup of key tables every time I make changes to them or the data.

That method is to copy the table as demonstrated by Perry.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events