Taking Backup Of table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Taking Backup Of table

Taking Backup Of table

Rate Topic

Display Mode

Topic Options

Author

Message

Shadab Shah

Posted Monday, September 17, 2012 11:53 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 19, 2013 9:07 PM
Points: 162, Visits: 336

Hi all,
I have a table which has some 10 million records. Now i want to take backup of this table but backup of 10 million records is not required we only need back of 1 million records? In this case what are we going to do.

I know how to take full backup of database but how to take backup of this 1/10 th data

Post #1360571

anthony.green

Posted Tuesday, September 18, 2012 1:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

back the data you want up into another table

something like this

select * into tablename_backup from tablename where somecol = 1000

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1360604

Shadab Shah

Posted Tuesday, September 18, 2012 2:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 19, 2013 9:07 PM
Points: 162, Visits: 336

anthony.green (9/18/2012)

back the data you want up into another table

something like this

select * into tablename_backup from tablename where somecol = 1000

Hi since i am newbie in SQL Server, This solution seems to me as a long path which may not be true but what can be the another way of doing this.

Post #1360620

anthony.green

Posted Tuesday, September 18, 2012 2:24 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You cannot take a backup of an individual table or a subset of that tables data by any normal native backup routines.

The only options are to export the data into a flat file or another table / database.

For flat file use the import / export data wizard or SSIS

For other table / database use the soltution I have already provided above.

Otherwise backup the whole database.

Post #1360622

george sibbald

Posted Tuesday, September 18, 2012 5:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 5,269, Visits: 11,208

another option is the bcp utility with the 'query' parameter

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

Post #1360705

« Prev Topic | Next Topic »

Permissions